My IF formula has too many arguments

[Kris K]

Hello,


I have created the below formula but excel (2010 version) is telling me that I used too many arguments.


When I had it for "L" only it accepted the argument. So right now I'm facing with one option and that is spliting up "L" and "S" between two target cells. Is there a way I can make this formula work so It can be under one taget cell? ... I though under excell 2010 you can seed up tp 64 if formulas.


=IF(AND(A9="L",D9>=70),0,IF(AND(A9="L",D9>50),12.5,IF(AND(A9="L",D9>30),10,IF(AND(A9="L",D9<=30),15,0,IF(AND(A9="S",D9>=70),15,IF(AND(A9="S",D9>50),10,IF(AND(A9="S",D9>30),12.5,IF(AND(A9="S",D9<=30),0,0))))))))


I appreciate any and all input!

 

[Hui]

Your if isn't properly constructed

In the middle you have a ,15,0,if

That is causing a problem

Try changig to ,15,if

 

[Kris K]

Thank you. That was it. I foregot about it since I first constructed the formula for "L" only and once it worked I included the second half for "S" but I didn't realize the 0 at the end of "L" ifs would cause an issue.


Thanks again!

 

[vijaysin2000]

My formula in Excel says too many arguments.


The payment schedule is as below:


<= 25K, 3%

for next 25 K 5%

for next 25K 6%

for next 25K 8%

> 100K 10%


=if(F10<=25000,0.03*F10, if(AND(F10>25000,F10<=50000),(0.03*25000+0.05*(50000-F10))), if(AND(F10>50000, F10<=75000),(0.08*25000+0.06*(75000-F10))),if(AND(F10>75000,F10<=100000),(0.14*25000+0.08*(100000-F10))),(0.22*25000+0.1*(F10-100000))))


Can you help please?


Rgds

Vijay

 

[Faseeh]

Hi Vijay,


Welcome to the forums!!!


""Cross-Posting is general considered bad practice here so please start a new threat for every new question, also read the Green Sticky Posts on Forums Home Page ""


This thread might solve your problem:


http://chandoo.org/forums/topic/please-help-with-tier-based-billing-formula


Happy Posting!!

Faseeh

 

[shailyog]

Vijaysin2000:


you have added few more closing brackets that's why the problem is there. Based on the syntax of formula the correct formula is:

=IF(F10<=25000,0.03*F10,IF(AND(F10>25000,F10<=50000),(0.03*25000+0.05*(50000-F10)),IF(AND(F10>50000,F10<=75000),(0.08*25000+0.06*(75000-F10)),IF(AND(F10>75000,F10<=100000),(0.14*25000+0.08*(100000-F10)),(0.22*25000+0.1*(F10-100000))))))


But I think there is some problem in the logic also. you need to check it.