SOLVED

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

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)
)