new to excel programming, why is this happening?

[zalemam]

I'm typing a simple IF function but I keep getting an error that I have too many arguments in one function.

=IF(J3 > 0,J3,(C3-(C3*H3)),IF(H3= 0,C3,(C3-(C3*H3))))

Thanks :D

[Mallycat]

yes, that's because you have too many arguments in your function!!

The if function is in the form =if(test,answer if true, answer if false). i.e. only 3 arguments. You have 4 arguments. So delete the argument starting with the comma before the last IF statement, and it will work - i.e. it will have 3 arguments.

Now I am sure somehow you want the last If statement, but that is a different question, and you need to be specific about what you are trying to do.

[zalemam]

Thank You Mallcat,

Yes I do want the other function, How do I do that? Also why does this function work? : =IF(G3 <=8,0,IF(G3 <=14,0.15,IF(G3<=18,0.25,IF(G3 > 18,0.4)))) I am surely using more than three arguments right?

Thank You.

[Mallycat]

Because in the one you have just posted, the "answer if false" augment has been replaced with a second if statement. In your original formula, you added a fourth argument. you can keep nesting if statements as long as you replace one of the arguments with an entirely new (and complete) if statement.

[zalemam]

Got it!

Thanks Mallycat!