Negative value

F

Felipe

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

thanks in advance.
 
J

Jacob Skaria

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))
 
R

Rick Rothstein

If you don't want to use IF, then you can use MAX instead...

=MAX(0,<<your current formula goes here>>)
 
D

David Biddulph

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) ?
 
Top