SOLVED

Excel formula error...… you've entered too many arguments for this function. The IF function.

%3CLINGO-SUB%20id%3D%22lingo-sub-2895110%22%20slang%3D%22en-US%22%3EExcel%20formula%20error...%E2%80%A6%20you've%20entered%20too%20many%20arguments%20for%20this%20function.%20The%20IF%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2895110%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI've%20got%20two%20beginning%20options%20If%20cell%20J3%20is%20%22B%22%20then%20this%20formula%20applies%20to%20cell%20M3%26gt%3B%20%3DIF(M3%3D%22t%22%2CI3-F3%2CIF(M3%3D%22s1%22%2CG3-F3%2CH3-F3))%20and%20if%20the%20cell%20J3%20is%20%22S%22%20then%20the%20formula%20changes%20a%20bit%20to%20%26gt%3B%20%3DIF(M3%3D%22t%22%2CF3-I3%2CIF(M3%3D%22s1%22%2CF3-G3%2CF3-H3)).%20I%20combined%20the%20formula%20to%26gt%3B%20%3DIF(J3%3D%22b%22%2CM3%3D%22t%22%2CI3-F3%2CIF(M3%3D%22s1%22%2CG3-F3%2CH3-F3)%2CIF(M3%3D%22t%22%2CF3-I3%2CIF(M3%3D%22s1%22%2CF3-G3%2CF3-H3)))%20and%20thus%20I'm%20getting%20the%20error%20you've%20entered%20too%20many%20arguments%20for%20this%20function.....%20Any%20help%20reconciling%20this%20error%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2895110%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2895173%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20error...%E2%80%A6%20you've%20entered%20too%20many%20arguments%20for%20this%20function.%20The%20IF%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2895173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1198607%22%20target%3D%22_blank%22%3E%40ARRAGONKDEE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3D(1%20-%20(J3%3D%22S%22)*2)%20*%0A%20IF(%20M3%3D%22t%22%2C%20I3-F3%2C%0A%20IF(%20M3%3D%22s1%22%2CG3-F3%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20H3-F3)%0A)%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2895250%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20error...%E2%80%A6%20you've%20entered%20too%20many%20arguments%20for%20this%20function.%20The%20IF%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2895250%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E
New Contributor

I've got two beginning options If cell J3 is "B" then this formula applies to cell M3> =IF(M3="t",I3-F3,IF(M3="s1",G3-F3,H3-F3)) and if the cell J3 is "S" then the formula changes a bit to > =IF(M3="t",F3-I3,IF(M3="s1",F3-G3,F3-H3)). I combined the formula to> =IF(J3="b",M3="t",I3-F3,IF(M3="s1",G3-F3,H3-F3),IF(M3="t",F3-I3,IF(M3="s1",F3-G3,F3-H3))) and thus I'm getting the error you've entered too many arguments for this function..... Any help reconciling this error?

3 Replies
best response confirmed by ARRAGONKDEE (New Contributor)
Solution

@ARRAGONKDEE 

It could be

=(1 - (J3="S")*2) *
 IF( M3="t", I3-F3,
 IF( M3="s1",G3-F3,
             H3-F3)
)