If Statement Error
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? |
If Statement Error
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? |
If Statement Error
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" wrote: 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? |
If Statement Error
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" wrote: 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" wrote: 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? |
All times are GMT +1. The time now is 12:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com