Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |