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?

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?

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?

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?

The format won't make a difference.

Try,

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

Rgds



On Sat, 15 Oct 2005 08:01:03 -0700, "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?


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

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.


"JE McGimpsey" wrote:

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?

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
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476499

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


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476499

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.


In article ,
"skateblade" wrote:

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.


"JE McGimpsey" wrote:

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?

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

"Richard Buttrey" wrote:

The format won't make a difference.

Try,

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

Rgds



On Sat, 15 Oct 2005 08:01:03 -0700, "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?


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

One more crack at it<g

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


Gord Dibben Excel MVP

On Sat, 15 Oct 2005 10:30:32 -0700, "skateblade"
wrote:

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

"Richard Buttrey" wrote:

The format won't make a difference.

Try,

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

Rgds



On Sat, 15 Oct 2005 08:01:03 -0700, "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?


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

TO REMOVE THE 0's:

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

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

Regards,
CPisani


--
pisanichris
------------------------------------------------------------------------
pisanichris's Profile: http://www.excelforum.com/member.php...o&userid=28138
View this thread: http://www.excelforum.com/showthread...hreadid=476499