Need the cell to show blank

S

skateblade

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?
 
S

skateblade

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.
 
J

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.
 
R

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.
Click to expand...

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
S

skateblade

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.
 
L

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.
 
J

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.
 
S

skateblade

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

Gord Dibben

One more crack at it<g>

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


Gord Dibben Excel MVP
 
P

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
 
Top