Help with nested (x3) IF formula


#1

Hi there,

wondering if someone can help me design the correct nested IF formula to handle the following.

I enter a value into a cell and I want Airtable to then do the following;

IF the value of the cell is < 38, then x the value by .66 and place the sum into that new cell
or
IF the value of that cell is 38 to 277 then place the value of 25 into that new cell
or
IF the value of that cell is > 278 then x the value of that cell by 0.09 and enter that value into the new cell

Help please and thank you!


#2

This is a very specific request, but here’s what I came up with quickly that should solve meet the requirements:

IF(NUM<38,NUMx0.66,IF(AND(NUM>=38,NUM<277),25,NUMx0.09))

note: switch out “x” for multplication operator (auto formatting seems to remove it here)


#3

Thank you! I’ll give that a go now and see how it pans out!