Help with Excel Nested IF Statement - TechRepublic
Question
October 13, 2008 at 08:48 AM
dcrackley

Help with Excel Nested IF Statement

by dcrackley . Updated 14 years, 4 months ago

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

This discussion is locked

All Comments