If Statement Error

[Kiley]

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?

 

[T. Valko]

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,"")))

 

[Elkar]

You have a couple extra "" in there. You only need to supply the ""
condition at the very end of the formula. Try 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,"")))

HTH
Elkar

 

[Kiley]

That worked. Now I have another question. Can I pull in some sort of lookup
value for this IF statement. For example, I have a row of information (all of
the IF statment information) for each person. I want to identify the row of
information to look at.

You have a couple extra "" in there. You only need to supply the ""
condition at the very end of the formula. Try 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,"")))

HTH
Elkar

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?