Questions

Help with Excel Nested IF Statement

Tags:
+
0 Votes
Locked

Help with Excel Nested IF Statement

dcrackley
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(G2<DATE(2008,8,1),F2<DATE(2008,7,1)),SUM(G2-DATE(2008,7,1))/H2*100,IF(AND(G2>DATE(2008,8,1),F2>DATE(2008,7,1)),SUM(DATE(2008,8,1)-F2))/H2*100,IF(AND(G2>DATE(2008,8,1),F2<DATE(2008,7,1)),SUM(31/H2*100)))