one way:

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

Regards

Trevor


"S Girl" wrote in message
...
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.