You don't need all the ,"", arguments. You only need one at the very end of
the formula. Try it like this:

=IF('[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AV$4="y",'[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AR$4,IF('[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BC$4="y",'[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AY$4,IF('[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BJ$4="y",'[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BF$4,"")))


--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
I have the following "IF" statement:

=IF('[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AV$4="y",'[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AR$4,"", IF('[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BC$4="y",'[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AY$4,"", IF('[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BJ$4="y",'[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BF$4,"")))

and then I get the following error:
"You've entered too many arguments for this function. To help with
entering
arguments for the function, click OK to close this message. Then, one the
formula bar, click the equal sign button (located to the left of the equal
sign in your formula)."

I do not have an equal sign button and I cannot figure out how make one
appear.

Does anyone know how go fix my formula or make the equal sign appear?