Forum Discussion

ARRAGONKDEE's avatar
ARRAGONKDEE
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="...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 28, 2021

    ARRAGONKDEE 

    It could be

    =(1 - (J3="S")*2) *
 IF( M3="t", I3-F3,
 IF( M3="s1",G3-F3,
             H3-F3)
)
SergeiBaklan's avatar
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's avatar
ARRAGONKDEE
Copper Contributor
Oct 28, 2021
Thank you!

Resources