Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Contributor III

## Concatenate If Statements to Expressions

Hi guys,

I am currently trying to set up a formula, that helps me classify customers by good, neutral, bad as follows:

=if(

([OfflineSales2018]>[OfflineSales2017]

and

[OnlineSales2018]>[OnlineSales2017]

and

([OfflinePositions2018]>[OfflinePositions2017]

and

[OnlinePositions2018]>[OnlinePositions2017]

, 'good')

if(

([OfflineSales2018]>[OfflineSales2017]

and

[OnlineSales2018]>[OnlineSales2017]

and

([OfflinePositions2018]<[OfflinePositions2017]

and

[OnlinePositions2018]<[OnlinePositions2017]

, 'neutral')

if(

([OfflineSales2018]<[OfflineSales2017]

and

[OnlineSales2018]<[OnlineSales2017]

and

([OfflinePositions2018]<[OfflinePositions2017]

and

[OnlinePositions2018]<[OnlinePositions2017]

Could anyone please help me solve this riddle and make it work exactly that way? Thank you 🙂

Best regards

Nes

1 Solution

Accepted Solutions
Champion

Hi,

try this:

=if(

[OfflineSales2018]>[OfflineSales2017]

and

[OnlineSales2018]>[OnlineSales2017]

and

[OfflinePositions2018]>[OfflinePositions2017]

and

[OnlinePositions2018]>[OnlinePositions2017]

, 'good',

if(

[OfflineSales2018]>[OfflineSales2017]

and

[OnlineSales2018]>[OnlineSales2017]

and

[OfflinePositions2018]<[OfflinePositions2017]

and

[OnlinePositions2018]<[OnlinePositions2017]

, 'neutral',

if(

[OfflineSales2018]<[OfflineSales2017]

and

[OnlineSales2018]<[OnlineSales2017]

and

[OfflinePositions2018]<[OfflinePositions2017]

and

[OnlinePositions2018]<[OnlinePositions2017]

3 Replies
Champion

Hi,

try this:

=if(

[OfflineSales2018]>[OfflineSales2017]

and

[OnlineSales2018]>[OnlineSales2017]

and

[OfflinePositions2018]>[OfflinePositions2017]

and

[OnlinePositions2018]>[OnlinePositions2017]

, 'good',

if(

[OfflineSales2018]>[OfflineSales2017]

and

[OnlineSales2018]>[OnlineSales2017]

and

[OfflinePositions2018]<[OfflinePositions2017]

and

[OnlinePositions2018]<[OnlinePositions2017]

, 'neutral',

if(

[OfflineSales2018]<[OfflineSales2017]

and

[OnlineSales2018]<[OnlineSales2017]

and

[OfflinePositions2018]<[OfflinePositions2017]

and

[OnlinePositions2018]<[OnlinePositions2017]