# IF command query

I'm trying to calculate different percentages for the same cell. Let's say for arguments sake it's cell `A1`:

``````If A1 <   50000 then multiply by 10%
If A1 >   50000 then multiply by 12.5%
If A1 > 1000000 then multiply by 15%
``````

I'm trying to use an IF formula but it won't let me put three conditions, just two.

How do I achieve this?

-
If you set up a lookup table, say in E:F, a quite simple formula might suffice `=VLOOKUP(A1,E:F,2)*A1` and be easier to extend should you wish later to add additional breakpoints. – pnuts Apr 10 '13 at 13:27

You'll need to decide what to do if A1 = 50000 or if A1 = 1000000, but this should get you started. Put this formula in cell B1 and copy it down:

=IF(A1>1000000,A1*0.15,IF(A1>50000,A1*0.125,IF(A1<50000,A1*0.1,)))

You can easily change the > to a >=, depending on your decision.

-
thank you guys! – claire Apr 10 '13 at 14:41
You are welcome, Claire....Could you please "upvote" the answer (in addition to the checkmark? :-) ) – F106dart Apr 10 '13 at 18:41
Upvoting requires a reputation of 15 – Axel Kemper Apr 11 '13 at 17:32
`IF(A1<50000,` and the final parenthesis are redundant here. – pnuts May 1 '13 at 13:53

First of all this IF(A1<50000;A1=A1/10) it is circular and will not work you can not change a cell from another shell unless you use VBA I asume that you need something like this

```=IF(A1<50000;A1*(10/100);IF(A1<=100000;A1*(15/100);A1*(12,5/100))) ```

-
thank you - yes the above seems correct but it is giving me an error in excel? – claire Apr 10 '13 at 13:19
Could be due to the language settings. You might need commas in place of semicolons and a full stop in place of the comma. – pnuts Apr 10 '13 at 13:23