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.
|