Nested IF formula =IF(M23<S23,S23,M23),IF(S23="",M23,S23) is NOT working

[Tenywerre]

My formula =IF(M23<S23,S23,M23) works great by it's self and formula IF(S23="",M23,S23) works great by it's self. When merge them I am getting a #VALUE! error and I don't know what I am missing or doing wrong. Any help is very much appreciated.

Thank you in advance.

 

[6StringJazzer]

You can't string together two IF statements like that. What you show in your thread title is not a nested formula, it's just two IF functions joined by a comma.

I would rewrite your first formula to use MAX:

=MAX(M23,S23)

Here is my best guess as to what you want: If S23 is blank, the formula returns M23. (That's what your second formula does.) But if S23 is not blank, then it goes on to return the larger of M23 or S23.

=IF(S23="",M23,MAX(M23,S23))

If that is not what you need then please describe what you want the formula to do. Don't think in terms of merging your other two formulas, just describe what outcome you want.

 

[Scott Huish]

If you don't have negative numbers at all, the MAX formula 6String gave you might accomplish everything by itself.
If S23 is blank, it will evaluate as 0, and then it would return M23 because that value would be larger than zero (or zero itself)