I am new to using Excel (using 2016) and I am trying to make this formula work, but it won't. The formula is if(c10>0,e9-c10,0,if(d10>0,e9+d10,0)). When I try to use this formula, it says "too many arguments". The formula works when I take out the value if false i.e., 0s but when I add them it doesn't.
3 Answers
The IF function takes three arguments:
- logical test
- value if logical test is true
- value if logical test is false
It can be used with only two arguments. You're calling it with four.
You say it works when you take out the value if false, i.e., 0.
What value do you want the formula to have if c10>0 is false?
- if you want it to be
0, why are you sayingif(d10>0,e9+d10,0)? - if you want it to be
if(d10>0,e9+d10,0), don't throw in the extra0.
HI Please try this maybe can halp you:
=IF(E12>=4;"Excellent";IF(E12>=3;"Good";IF(E12>=2;"average";IF(E12>1;"Sufficient";IF(E12>=0;"Insufficient / Fail")))))
1First of all, I would like to say thank you to everyone who helped me out. this is a great community and I intend to become a contributing member. Someone suggested evaluating the formula and when I ran the evaluation tool on "=IF(C11>0, E10-C11,IF(C11=0,0,IF(D11>0,E10+D11,IF(D11=0,0))))", it would end up stopping at the c11-0,0 part when c11 would be 0 and would not run through the rest of the formula. this is why it wasn't doing the adding part. when I took that part out it worked perfectly. the formula ended up being "=IF(C11>0, E10-C11,IF(D11>0,E10+D11,IF(D11=0,0))))". for some reason "d11=0,0" didn't matter. thanks again for all your help guys.
1
