Oct 28 2021 04:00 AM
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?
Oct 28 2021 04:23 AM
SolutionOct 28 2021 04:46 AM
Oct 28 2021 05:46 AM
@ARRAGONKDEE , glad to help
Oct 28 2021 04:23 AM
SolutionIt could be
=(1 - (J3="S")*2) *
IF( M3="t", I3-F3,
IF( M3="s1",G3-F3,
H3-F3)
)