Thread: cell calculation check if result is negative and zero out if not l
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default cell calculation check if result is negative and zero out if not l
=MAX(0,(B5-A5))

Vaya con Dios,
Chuck, CABGx3



"Rich" wrote:

Formula in cell =(B5-A5) I want to check if result is negative and if so
replace result with 0

So this cell will either be a positive number or zero.


Reply With QuoteReply With Quote