Thread: Neative Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Neative Formula

Without creating a custom number format, you could use a formula like this,
assuming the two numbers are cells A1 and A2
=IF(A1-A2<0,0,A1-A2)


"jen" wrote:

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.