| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative value
How can i change the negative result of a formual into cero "0".
PS: dont want to use the If apliation. thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative value
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative value
If you don't want to use IF, then you can use MAX instead...
=MAX(0,<<your current formula goes here) -- Rick (MVP - Excel) "Felipe" wrote in message ... How can i change the negative result of a formual into cero "0". PS: dont want to use the If apliation. thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative value
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing color of negative bar when using Invert if negative | Charts and Charting in Excel | |||
| I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Linear Mode
