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
IF the value of that cell is 38 to 277 then place the value of 25 into that new cell
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!