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.