Software

Ask something
Question Locked

Help with Excel Nested IF Statement

0 helpful
5 replies

by dcrackley

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to figure out why this formula is not working: It works up uwhen until the 3rd IF statement, but when I nest the 3rd IF statement it is giving me the error: "You have entered too many arguments...". Can you all see anything wrong with the formula? Have I entered to many functions in the formula?

=IF(AND(G2DATE(2008,8,1),F2>DATE(2008,7,1)),SUM(DATE(2008,8,1)-F2))/H2*100,IF(AND(G2>DATE(2008,8,1),F2

5 replies

by Former member

"IF" Function...
Between each argument of the IF function, the comma is used as a separator. The comma is what tells Excel when each argument of IF function ends and the next section begins.
http://spreadsheets.about.com/od/iffunctions/Excel_IF_Functions.htm

"And" function..
http://spreadsheets.about.com/od/excelfunctions/qt/and_function.htm
Just a thought. :)

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks

by chris910

=IF(AND(G2DATE(2008,8,1),F2>DATE(2008,7,1)),SUM(DATE(2008,8,1),-F2))/H2*100,IF(AND(G2>DATE(2008,8,1),F2

by kaos93

Need help with multiple nested IF statements in excel. I am trying to do a tier bonus sales spreadsheet that has if this than this, or if this than this, it is 6 if statements all together.
what i have so far: =IF(G3>0,G3<50,G3*0),IF(G3>50,G3<100,G3*5) but not calculating.

This discussion is closed to new replies.