For reasons which aren't clear, the OP said "dont want to use the If
apliation.", so perhaps you could change your
=IF(SUM(A1:C1)<0,0,SUM(A1:C1)) to =MAX(SUM(A1:C1),0) ?
--
David Biddulph

"Jacob Skaria" wrote in message
...
One way is to handle that with IF condidtion as below

=IF(formula<0,0,formula)

If formula is

=SUM(A1:C1)
modify that to

=IF(SUM(A1:C1)<0,0,SUM(A1:C1))

--
If this post helps click Yes
---------------
Jacob Skaria


"Felipe" wrote:

How can i change the negative result of a formual into cero "0".
PS: dont want to use the If apliation.

thanks in advance.