If Statement Error

K

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

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

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
 
K

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.


Elkar said:
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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top