Home

IF Function error

%3CLINGO-SUB%20id%3D%22lingo-sub-792650%22%20slang%3D%22en-US%22%3EIF%20Function%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792650%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20create%20a%20'Nested%20IF'%20function%2C%20(putting%20an%20IF%20statement%20in%20an%20IF%20statement)%20however%20it%20returns%20with%20the%20error%20of%20having%20too%20many%20arguments%20in%20this%20function.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125971i8CBE6639788E245E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20above%20is%20my%20formula.%3C%2FP%3E%3CP%3EI%20am%20entering%20this%20into%20cell%20M2%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-792650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792872%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792872%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388450%22%20target%3D%22_blank%22%3E%40G00dman%3C%2FA%3E%3C%2FSPAN%3E%2C%3C%2FP%3E%3CP%3EPlease%20try%20following%20formula%20in%20M2.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5B%40%5BSales%20Person%5D%5D%3D%22M%22%2C%5B%40Profit%5D%2C%20IF(%5B%40%5BSales%20Person%5D%5D%3D%22M%2FMPB%22%2C%5B%40Profit%5D*0.8%2C%20%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E0%3C%2FSTRONG%3E%3C%2FFONT%3E))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%2C%20the%20formula%20returns%200%20(zero)%20if%20the%20sales%20person%20is%20neither%20M%20nor%20M%2FMPB.%20If%20you%20need%20some%20other%20value%2C%20please%20replace%20the%20zero%20in%26nbsp%3B%26nbsp%3B%3CFONT%20color%3D%22%23FF0000%22%3Ered%3C%2FFONT%3Efont%20with%20right%20value.%26nbsp%3B%20hope%20this%20helps!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
G00dman
New Contributor

Trying to create a 'Nested IF' function, (putting an IF statement in an IF statement) however it returns with the error of having too many arguments in this function.

clipboard_image_0.png

The above is my formula.

I am entering this into cell M2

1 Reply

Hi @G00dman,

Please try following formula in M2.  

=IF([@[Sales Person]]="M",[@Profit], IF([@[Sales Person]]="M/MPB",[@Profit]*0.8, 0))

 

Please note, the formula returns 0 (zero) if the sales person is neither M nor M/MPB. If you need some other value, please replace the zero in  red font with right value.  hope this helps!!