How can I describe three different situations on a cell in Numbers
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