Thread: How to set minus value to 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TSK TSK is offline
external usenet poster
  
Posts: 21
Default How to set minus value to 0
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
Reply With QuoteReply With Quote