Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
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

2 Answers 2

up vote 0 down vote accepted

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.

share|improve this answer
    
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
1  
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)))

share|improve this answer
    
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.