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

=IF(AND(Z170,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.

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

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

=IF(AND(Z170,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"))))))


"TaraD" wrote in message
...

=IF(AND(Z170,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.




--
TaraD

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

Right in the beginning, you have
=IF(AND(Z170,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

"TaraD" wrote in message
...


=IF(AND(Z170,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.




--
TaraD