View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yshridhar yshridhar is offline
external usenet poster
 
Posts: 229
Default How to set minus value to 0

=if((b1-a1)<=0,0,value)
Best wishes
Sreedhar

"TSK" wrote:

How to focus the value to zero after minus from 2 cells otherwise show the
actual value different?

A1 - 100 / B1 - 50


If B1 - A1 is not <= 0 show the value different and if B1 - A1 is <=0 then
reflect the number as 0