Concatenate If Statements to Expressions

[nesonica]

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]

, 'bad')

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

Best regards

Nes

[YoussefBelloum · Accepted solution]

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]

, 'bad')))

[nesonica]

Thank you so much, Youssef! It worked perfectly. 🙂

[YoussefBelloum]

You're welcome

good luck