SOLVED

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

Copper 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 (Copper Contributor)
Solution

@ARRAGONKDEE 

It could be

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

Accepted Solutions
best response confirmed by ARRAGONKDEE (Copper Contributor)
Solution

@ARRAGONKDEE 

It could be

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

View solution in original post