0

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?

  • What is it? A cell? – JBis Jul 10 '18 at 12:33
3

Let B3 be the cell you are trying to reference.

=IF(B3>35,B3×0.75,IF(B3<25,B3×0.7,B3×0.72))

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .