Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
handle error in IF ELSEIF statement | Excel Worksheet Functions | |||
using error type and if statement to return a value. | Excel Worksheet Functions | |||
If statement error check | Excel Worksheet Functions | |||
Can't fix On Error statement | Excel Discussion (Misc queries) | |||
IF statement error | Excel Discussion (Misc queries) |