Enter "0" is number is negative

[S Girl]

I have a row that is calculating figures and some of
numbers are positve and some are negative. How do I tell
it to enter a zero, if the calculation returns a negative
number and enter the positive number if the calculation is
postive.

 

[Trevor Shuttleworth]

one way:

=IF(SUM(A1:H1)>0,SUM(A1:H1),0)

Regards

Trevor

 

[Frank Kabel]

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