excel formula

[Guest]

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

 

[Richard Buttrey]

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

And if it isn't????


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Peo Sjoblom]

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

will retrun zero of condition is FALSE

Regards,

Peo Sjoblom

 

[Harlan Grove]

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)

?

 

[Guest]

And if it isn't then leave blank

And if it isn't????


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

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?

 

[Gord Dibben]

Difference between what?

Between 37.5 and current value?

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


Gord Dibben Excel MVP

 

[Richard Buttrey]

And if it isn't then leave blank

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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Harlan Grove]

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),"")

 

[Guest]

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