What is Wrong with this function??????????

T

TaraD

=IF(AND(Z17>0,Z17<=12),Z17+12,Z17,IF(AA17<=7,".00",IF(AA17<=22,0.25,IF(AA17<=37,0.5,IF(AA17<=52,0.75,IF(AA17<60,".00"))))))

For the Love I cannot find the problem. Excel says there are too many
arguments for the function.
Someone please please please Help.
 
P

PCLIVE

Theres a snag at Z17. You may want to remove that part.

=IF(AND(Z17>0,Z17<=12),Z17+12,

Z17,

IF(AA17<=7,".00",IF(AA17<=22,0.25,IF(AA17<=37,0.5,IF(AA17<=52,0.75,IF(AA17<60,".00"))))))
 
B

Bob Umlas

Right in the beginning, you have
=IF(AND(Z17>0,Z17<=12),Z17+12,Z17)
which is totally sufficient for the If-statement. The TRUE part is Z17+12,
and the FALSE part is Z17. But instead of ending the function there, you
have another comma, and another IF statement, which is what Excel is
complaining about.
You should remove either the Z17+12 or the Z17, or rething the whole thing!
Bob Umlas
Excel MVP
 
Top