Is it possible to layer more than one IF func...

[Russell_Van]

Is it possible to layer more than one IF function?

Eg: =IF([No. of Days]<2,LOOKUP(‘1’, ‘Prices’, ‘Days’, ‘Set Prices’)[No. of Days],0),IF([No. of Days]>1or <8,LOOKUP(‘2 to 7’, ‘Prices’, ‘Days’, ‘Set Prices’)[No. of Days],0)

Something like this… (This one doesn’t work just an example…)

I have a cerctian price for 1 day (100) and a different price for 2 to 7(80) days…

[David_Hopkins]

Oh yeah!

I have one crazy display that has 4.

[Russell_Van]

@David_Hopkins Dude! Please could you show me an example?

[John_Gardner]

You may also want to use the SWITCH function instead of IF.

https://help.appsheet.com/expressions/expression-types/conditional-expressions

[David_Hopkins]

@John_Gardner I love switch when there are multiple options. I’ve even started playing with a switch that will run a different SELECT statement based on the value of a col. so, I can get different results depending on what type of element is being viewed.

[Russell_Van]

@John_Gardner @David_Hopkins Thanks guys! I’m back on track.