What do you mean by "the answer", then?

The only way "the answer" to "=MAX(0, 37.5-M9)" could be zero is if M9
is greater than or equal to 37.5.

That's what my formula's conditional tests for.

In article ,
"skateblade" wrote:

Thanks for the response.
I tried it and it returned 37.5 in the cell. I don't know if it makes a
difference, the cell is formated as a number with 1 decimal.
I ned it to show a blank cell.

"JE McGimpsey" wrote:

One way:

=IF(M9=37.5, "", 37.5-M9)

In article ,
"skateblade" wrote:

I have a formula =MAX(0,37.5-M9) and I need the cell to show blank if the
answer is 0. What can I change?