Thank You, It didn't work. Is there a way of the cell can be blank when the
cell shows 37.5

"Richard Buttrey" wrote:

On Fri, 14 Oct 2005 11:09:01 -0700, "skateblade"
wrote:


And if it isn't then leave blank


"Richard Buttrey" wrote:

On Fri, 14 Oct 2005 09:52:17 -0700, "skateblade"
wrote:

If cell M6 is less than 37.5 then calculate the difference.

And if it isn't????


=if(M6<37.5,M6-37.5,"")

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________