Make a negative # =0

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Any way to make when a calculation comes out with a negative # to make
the result 0?

i.e. have a formula like =sum(a1-a2)
a1= 5
a2 =7
result =-2 but I want it to be 0, any way to do that?

Thanks,

Frank
 
Hi Frank!

Try:

=IF((A1-A2)<0,0,A1-A2)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
or MAX(0,A1-A2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top