Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zeros
Why, in the result of a formula, does "0" sometimes appear as 0.00, (0.00),
or -? The formula and the formatting on all cells is the same and is a simple formula like A4-B4. Thanks -- Allan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zeros
I would select all those cells and format them alike.
"Flipper" wrote in message ... Why, in the result of a formula, does "0" sometimes appear as 0.00, (0.00), or -? The formula and the formatting on all cells is the same and is a simple formula like A4-B4. Thanks -- Allan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zeros
So what formatting do you think the cells do have?
Tell us what format the cell has for each of your results 0.00 (0.00) - I would bet that they are NOT all the same format. -- David Biddulph "Flipper" wrote in message ... Why, in the result of a formula, does "0" sometimes appear as 0.00, (0.00), or -? The formula and the formatting on all cells is the same and is a simple formula like A4-B4. Thanks -- Allan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zeros
Hi,
If the difference between A4 and B4 is very small but positive but you are only displaying 2 decimals you could see 0.00. If the difference is very small but negative you could see (0.00) and if the result was exactly 0 you might see - The format for this would be 0.00_);(0.00);- -- If this helps, please click the Yes button Cheers, Shane Devenshire "Flipper" wrote: Why, in the result of a formula, does "0" sometimes appear as 0.00, (0.00), or -? The formula and the formatting on all cells is the same and is a simple formula like A4-B4. Thanks -- Allan |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zeros
"Shane Devenshire" wrote:
If the difference between A4 and B4 is very small but positive but you are only displaying 2 decimals you could see 0.00. If the difference is very small but negative you could see (0.00) and if the result was exactly 0 you might see -[.] The format for this would be 0.00_);(0.00);- Or simply Accounting with "none" for Symbol. And with the default of 2 decimal places, the difference can be as large as about 0.0049... (meaning any number of 9s). The situation can be avoided by the prudent and prolific use of the ROUND function, for example ROUND(A4-B4,2). And if A4 and B4 have values derive from expressions, not just constants, it might be prudent to use =ROUND(formula,2) in each of those cells. PS: You might think that if you use ROUND(formula,2) in each of A4 and B4, you should not need ROUND(A4-B4,2). But it would be better if you did the latter as well to ensure that you do not encounter any surprises in other formulas that might depend on that cell value. ----- original message ----- "Shane Devenshire" wrote in message ... Hi, If the difference between A4 and B4 is very small but positive but you are only displaying 2 decimals you could see 0.00. If the difference is very small but negative you could see (0.00) and if the result was exactly 0 you might see - The format for this would be 0.00_);(0.00);- -- If this helps, please click the Yes button Cheers, Shane Devenshire "Flipper" wrote: Why, in the result of a formula, does "0" sometimes appear as 0.00, (0.00), or -? The formula and the formatting on all cells is the same and is a simple formula like A4-B4. Thanks -- Allan |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zeros
Sorry about this response to an old thread that is surely no longer of
interest. My mistake in OE usage. ----- original message ----- "JoeU2004" wrote in message ... "Shane Devenshire" wrote: If the difference between A4 and B4 is very small but positive but you are only displaying 2 decimals you could see 0.00. If the difference is very small but negative you could see (0.00) and if the result was exactly 0 you might see -[.] The format for this would be 0.00_);(0.00);- Or simply Accounting with "none" for Symbol. And with the default of 2 decimal places, the difference can be as large as about 0.0049... (meaning any number of 9s). The situation can be avoided by the prudent and prolific use of the ROUND function, for example ROUND(A4-B4,2). And if A4 and B4 have values derive from expressions, not just constants, it might be prudent to use =ROUND(formula,2) in each of those cells. PS: You might think that if you use ROUND(formula,2) in each of A4 and B4, you should not need ROUND(A4-B4,2). But it would be better if you did the latter as well to ensure that you do not encounter any surprises in other formulas that might depend on that cell value. ----- original message ----- "Shane Devenshire" wrote in message ... Hi, If the difference between A4 and B4 is very small but positive but you are only displaying 2 decimals you could see 0.00. If the difference is very small but negative you could see (0.00) and if the result was exactly 0 you might see - The format for this would be 0.00_);(0.00);- -- If this helps, please click the Yes button Cheers, Shane Devenshire "Flipper" wrote: Why, in the result of a formula, does "0" sometimes appear as 0.00, (0.00), or -? The formula and the formatting on all cells is the same and is a simple formula like A4-B4. Thanks -- Allan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zeros and #DIV/0! | Excel Discussion (Misc queries) | |||
when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
Charting zeros as non zeros | Charts and Charting in Excel | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |