View Single Post
  #3  
Old June 11th, 2004, 09:35 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Enter "0" is number is negative

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

--
Regards
Frank Kabel
Frankfurt, Germany


S Girl wrote:
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.