Need help with a "IF Then" formula

  • Thread starter Thread starter RGT
  • Start date Start date
R

RGT

I need a if/then statement that will basically show the following



if sum is less than zero then sum=0
else show sum.


Thanks,
Russ
 
=MAX(0,SUM(A1:A10))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top