Thread: Eliminate Negatives
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
  
Posts: 320
Default Eliminate Negatives
=MAX(0,B2-B3)

"MCheru" wrote in message
...
This formula (= B2 - B3) is in cell B5. I want to modify (= B2 - B3) so
that
if the answer is a negative number a "0" will appear in cell B5 instead of
a
negative number.


Reply With QuoteReply With Quote