I have a tier pricing first 10 units @ $100 next 15 units @ $50 and any further units @$25
For example for 7 units the cost is $700. For 11 = $1050 and for 30 it should be $1875
I tried to put the following formula but i get an error of too many arguments.
=IF(P10<10,(P10*100),IF(P10>10<26,10*100+P10-10*50),if(P10>26,10*100+15*50+((P10-25)*25)))
3 Answers
The IF function only accepts a maximum of 3 arguments. The error occurred because you closed the bracket after this IF(P10>10<26,10*100+P10-10*50). Thus having 4 arguments. The bracket must be removed. Then, you must insert it at the end of your formula.
You also have another problem with your formula: P10>10<26. If you are trying to compare when P10 is greater than 10 and less than 26, you should use AND(P10>10,P10<26).
How about building a pricing table and then using =VLOOKUP to calculate? Below is an example:
Change the formula to:
=IF(P10<10,(P10*100),IF(AND(P10>10,P10<26),10*100+P10-10*50,IF(P10>26,10*100+15*50+((P10-25)*25))))
