Need the cell to show blank

[Guest]

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?

 

[JE McGimpsey]

One way:

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

 

[Guest]

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]

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.

 

[Richard Buttrey]

The format won't make a difference.

Try,

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

Rgds

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.

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

Thanks,
The formulas works but when the answer is 0 i would like to cell to be blank
so I can't see the 0.

 

[Lilliabeth]

You said you wanted to show blank if the answer is zero.

Your answer apparently is not zero.

Your M9 is either zero or blank, which makes your correct answer be
37.5, not zero.

 

[Lilliabeth]

That is what you have. Is there some other issue?

 

[JE McGimpsey]

Well, you repeated yourself, but you didn't answer my question(s).

The formula I gave you produces a blank cell (null string) when the
answer to MAX(0, 37.5-M9) is zero. Every time.

If you'd like something else, you need to explain, not repeat.

 

[Guest]

Thanks, I tried it and it return the answer 37.5 in the cell. I need the cell
to be blank.

 

[Gord Dibben]

One more crack at it<g>

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


Gord Dibben Excel MVP

 

[pisanichris]

TO REMOVE THE 0's:

SELECT THE CELL/ROW/COLUMN, CLICK ON 'FORMAT', 'CONDITIONA
FORMATTING'.

Then set the condition that if that cell/s are equal to 0, you ca
choose a different format (font, background colour, text colour, tex
size, etc - in your case, that the text colour is white ( so it won'
show))

Regards,
CPisan