Thread: Neative Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Neative Formula

If your formula is =A1-A2, change it to =MAX(0,A1-A2)
Remember, of course that your example of 12000 - 10000 gives an answer of
+2000, not -2000.
--
David Biddulph

"jen" wrote in message
...
Hope this is easy (for you). Haven't used excel in a long time and need
to
create simple formula and can't figure it out.

Example: I want to show value as zero if addition comes out negative.

12000.00 -10000.00 = (2000.00) but I want the value to be zero not the
negative value.