| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Has Too Many Arguments
I am using Excel 2007 for Windows.
Excel complains that one of the functions in the following formula has too many arguments. I am not quite sure which function is the problem... Any suggestions on how to fix this? Thanks. =if(m4="IT1P",if(or(or(t4=40,n4="KAN"),and(t4=52,r 40)),ac$6/5*7+ad$6/5*7+ae$6/5*7+af$6+ag$6,if(t4=52,if(q4="E",ac$6/5*7+ad$6/5*7+s4+ae$6/5*7+af$6+ag$6,if(q4="F",ac$6/5*7+ad$6/5*7+o4+p4/5*7+ae$6/5*7+af$6+ag$6,"N/A")),"N/A"),"N/A"),if(m4="IT1L",if(or(n4="ACQ",n4="ERM",n4="MOF", n4="MOR",n4="PRO",r40),ac$4/5*7+ad$4/5*7+ae$4/5*7+af$4+ag$4,if(q4="E",ac$4/5*7+ad$4/5*7+s4+ae$4/5*7+af$4+ag$4,if(q4="F",ac$4/5*7+ad$4/5*7+o4+p4/5*7+ae$4/5*7+af$6+ag$6,"N/A"))),”N/A”),"N/A”) -- tb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum function changes arguments | Excel Worksheet Functions | |||
| FUNCTION arguments | Excel Worksheet Functions | |||
| function arguments | Excel Discussion (Misc queries) | |||
| MIN Function with arguments | Excel Worksheet Functions | |||
| IF function with too many arguments | Excel Worksheet Functions | |||
Threaded Mode
