Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=ROUND(A15-B15,2)
-- David Biddulph "Samuel" wrote in message ... 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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
You'll probably find that the cell isn't zero at all but is showing as zero because your only showing 2 decimal places. Try this to eliminate it but be aware it does change the value of the number =ROUND(A15-B15,2) Mike "Samuel" wrote: 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Computers work in binary, we work in decimals Here is everything you need to know about this issue (and more): http://support.microsoft.com/kb/78113/en-us http://support.microsoft.com/kb/42980 http://support.microsoft.com/kb/214118 http://www.cpearson.com/excel/rounding.htm http://docs.sun.com/source/806-3568/ncg_goldberg.html If this helps, please cliick the Yes button. -- Thanks, Shane Devenshire "Samuel" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |