Thread: excel formula
View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=(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.