View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Eliminate Negatives

Hi,

You can also try the follwing:

=if(B2-B3<0,0,B2-B3)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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.