| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative Zero (-0.00)
Hiya,
Im just doing a spreadsheet and have two columns auto-sumed (A15 & B15 show totals). I have a forumla in C15 which is '=A15-B15', yet the answer is coming out as -0.00 when in actual fact it should be 0.00 (without the negative in front). Is there a way to fix this as it is messing up other forumla's in the spreadsheet because it is a negative value and not a 'positive' zero. Thanks, Samuel. |
| 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 | |||
Threaded Mode
