How can I describe three different situations on a cell in Numbers We have business rules as follows:


If it is bigger than £35 we charge 75% of it  
If it is smaller than £20 we charge 70% of it  
If is is between 20 to 35 we charge 72% of it  


I don’t know how to set up a formula to automate this calculation in numbers. Is there a way to do this?
Let B3 be the cell you are trying to reference.

=IF(B3&gt;35,B3×0.75,IF(B3&lt;25,B3×0.7,B3×0.72))


More information on using IF functions can be found in the formulas reference for Numbers