excel formula
 

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

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


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

=(37.5-M6)*(M6<37.5)

will retrun zero of condition is FALSE

Regards,

Peo Sjoblom

"skateblade" wrote in message
...
If cell M6 is less than 37.5 then calculate the difference.

Peo Sjoblom wrote...
=(37.5-M6)*(M6<37.5)

will retrun zero of condition is FALSE
....

OK, but why not

=MAX(0,37.5-M6)

?

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


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Thanks, Both formulas worked but when we copy the cell down the sheet if the
others cells are blank, then the 37.5 apears until numbers are entered. Can
the formula be "hidden" so cell is blank?

"Harlan Grove" wrote:

Peo Sjoblom wrote...
=(37.5-M6)*(M6<37.5)

will retrun zero of condition is FALSE
....

OK, but why not

=MAX(0,37.5-M6)

?

Difference between what?

Between 37.5 and current value?

=IF(M6<37.5, 37.5-M6, "not less")


Gord Dibben Excel MVP

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

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

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
__________________________

"skateblade" wrote...
Thanks, Both formulas worked but when we copy the cell down the sheet
if the others cells are blank, then the 37.5 apears until numbers are
entered. Can the formula be "hidden" so cell is blank?
....

=IF(ISNUMBER(M6),MAX(0,37.5-M6),"")

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
__________________________