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?

Forum Discussion

Copper Contributor

Oct 28, 2021

Solved

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

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?

It could be

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

3 Replies

SergeiBaklan
Diamond Contributor
Oct 28, 2021
ARRAGONKDEE

It could be

=(1 - (J3="S")*2) * IF( M3="t", I3-F3, IF( M3="s1",G3-F3, H3-F3) )
- ARRAGONKDEE
  Copper Contributor
  Oct 28, 2021
  Thank you!
  - SergeiBaklan
    Diamond Contributor
    Oct 28, 2021
    ARRAGONKDEE , glad to help