Need help with a "IF Then" formula

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
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

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