Home

If Formula Error

%3CLINGO-SUB%20id%3D%22lingo-sub-909036%22%20slang%3D%22en-US%22%3EIf%20Formula%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909036%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20the%20if%20function%20below%20to%20display%20employee%20performance%20rankings.%20I%20created%20a%20base%20sheet%20to%20compile%20data%20from%20other%20sheets%2C%20and%20I%20created%20the%20equation%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(Base!E3%3D1%2C%20Base!A3%2C%20IF(Base!E4%3D1%2C%20Base!A4%2C%20If(Base!E5%3D1%2C%20Base!a5%2C%20if(Base!E6%3D1%2C%20Base!A6%2C%20If(Base!E7%3D1%2C%20Base!A7%2C%20If(Base!E8%3D1%2C%20Base!A8%2C%20If%20Base!E9%3D1%2C%20Base!A9%2C%20If(Base!E10%3D1%2C%20Base!A10%2C%20If(Base!E11%3D1%2C%20Base!A11%2C%20If(Base!E12%3D1%2C%20Base!A12%2C%20IF(Base!E13%3D1%2C%20Base!A13%2C%20If%20Base!E14%3D1%2C%20Base!E14))))))))))))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20hit%20enter%20to%20go%20to%20the%20next%20box%20and%20make%20its%20formula%2C%20I%20get%20a%20error%20that%20says%20I%20have%20too%20many%20arguements.%20Using%20Excel's%20built%20in%20F1%20help%20menus%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22You%20can%20nest%20up%20to%2064%20levels%20of%20functions%20in%20a%20formula.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20far%20less%20than%2064%20Levels.%20I%20am%20looking%20for%20some%20help%20as%20to%20how%20I%20can%20complete%20my%20task%2C%20as%20the%20formula%20in%20all%20cells%20I%20am%20looking%20to%20fill%20in%20need%20to%20have%20the%20same%20structure%20to%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-909036%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIF%20Formula%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909109%22%20slang%3D%22en-US%22%3ERE%3A%20If%20Formula%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909109%22%20slang%3D%22en-US%22%3ENevermind.%20I%20just%20found%20my%20mistake.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909106%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Formula%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909106%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424512%22%20target%3D%22_blank%22%3E%40bparker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20appears%20that%20you%20missed%20a%20couple%20of%20%22(%22%20marked%20in%20%3CFONT%20color%3D%22%23FF0000%22%3Ered%3C%2FFONT%3E.%3C%2FP%3E%3CP%3EAdditionally%2C%20you%20must%20finish%20the%20last%20argument%20of%20the%20last%20If()%20function%20marked%20in%26nbsp%3B%3CFONT%20color%3D%22%2300FF00%22%3Egreen%3CFONT%20color%3D%22%23000000%22%3E.%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIF(Base!E3%3D1%2C%20Base!A3%2C%20IF(Base!E4%3D1%2C%20Base!A4%2C%20If(Base!E5%3D1%2C%20Base!A5%2C%20If(Base!E6%3D1%2C%20Base!A6%2C%20If(Base!E7%3D1%2C%20Base!A7%2C%20If(Base!E8%3D1%2C%20Base!A8%2C%20%3CFONT%20color%3D%22%23FF0000%22%3E%3CFONT%20color%3D%22%23000000%22%3EIf%3C%2FFONT%3E(%3CFONT%20color%3D%22%23000000%22%3EBase!E9%3D1%2C%3C%2FFONT%3E%3C%2FFONT%3E%20Base!A9%2C%20If(Base!E10%3D1%2C%20Base!A10%2C%20If(Base!E11%3D1%2C%20Base!A11%2C%20If(Base!E12%3D1%2C%20Base!A12%2C%20IF(Base!E13%3D1%2C%20Base!A13%2C%20If%3CFONT%20color%3D%22%23FF0000%22%3E(%3C%2FFONT%3EBase!E14%3D1%2C%20Base!E14%2C%22%3CFONT%20color%3D%22%2300FF00%22%3EERROR%3C%2FFONT%3E%22))))))))))))%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
bparker
New Contributor

I am trying to use the if function below to display employee performance rankings. I created a base sheet to compile data from other sheets, and I created the equation below:

 

=IF(Base!E3=1, Base!A3, IF(Base!E4=1, Base!A4, If(Base!E5=1, Base!a5, if(Base!E6=1, Base!A6, If(Base!E7=1, Base!A7, If(Base!E8=1, Base!A8, If Base!E9=1, Base!A9, If(Base!E10=1, Base!A10, If(Base!E11=1, Base!A11, If(Base!E12=1, Base!A12, IF(Base!E13=1, Base!A13, If Base!E14=1, Base!E14))))))))))))

 

However, when hit enter to go to the next box and make its formula, I get a error that says I have too many arguements. Using Excel's built in F1 help menus,

 

"You can nest up to 64 levels of functions in a formula."

 

I have far less than 64 Levels. I am looking for some help as to how I can complete my task, as the formula in all cells I am looking to fill in need to have the same structure to it.

2 Replies

@bparker 

 

It appears that you missed a couple of "(" marked in red.

Additionally, you must finish the last argument of the last If() function marked in green.

 

=IF(Base!E3=1, Base!A3, IF(Base!E4=1, Base!A4, If(Base!E5=1, Base!A5, If(Base!E6=1, Base!A6, If(Base!E7=1, Base!A7, If(Base!E8=1, Base!A8, If(Base!E9=1, Base!A9, If(Base!E10=1, Base!A10, If(Base!E11=1, Base!A11, If(Base!E12=1, Base!A12, IF(Base!E13=1, Base!A13, If(Base!E14=1, Base!E14,"ERROR"))))))))))))

Nevermind. I just found my mistake.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies