F Felipe Jun 10, 2009 #1 How can i change the negative result of a formual into cero "0". PS: dont want to use the If apliation. thanks in advance.
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 Jun 10, 2009 #2 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))
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 Jun 10, 2009 #3 If you don't want to use IF, then you can use MAX instead... =MAX(0,<<your current formula goes here>>)
If you don't want to use IF, then you can use MAX instead... =MAX(0,<<your current formula goes here>>)
D David Biddulph Jun 10, 2009 #4 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) ?
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) ?
