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
__________________________