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…