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...

Hi guys, new to appsheet… Hope someone can help me out please. I’m making a parking lot management app where we charge peolpe to park per day. The price charged per day gets cheaper the longer you book your car in. Example: Days Set Prices/Rates 1 10...