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.