Dividing Problem

[DanMun]

Probably a dumb question! Example: Dividing an odd number rounds up until I move decimal point, but when I do that and remove numbers it leaves 0. in cell. I would like to have number divided exactly and then when numbers that effect this cell are removed for an empty cell to appear.

Thanks

 

[davesexcel]

Probably a dumb question! Example: Dividing an odd number rounds up until I move decimal point, but when I do that and remove numbers it leaves 0. in cell. I would like to have number divided exactly and then when numbers that effect this cell are removed for an empty cell to appear.

Thanks

Can you supply additional information?

 

[DanMun]

Can you supply additional information?

Cell C8 formula is =SUM(C6:C7). Cell D9 formula is C8/2 with formatting of number, custom, #. When entering the number 3 in cell C6 and the number 2 in cell C7, cell C8 shoes the correct answer of 5. Here's the problem, cell D9 has the formula =C8/2 but shows the number 3 and it should be 2.5. Now I can go up on the top and click the increase decimal button once and it changes the number in D9 which is the correct answer. Now when I delete the numbers in cells C6 and C7 what is showing in D9 is .0 and I can't figure it out!

 

[leigao84]

Empty cells are automatically designated as 0s in every formula...
Note that cells are displayed rounded, their true value is still in decimals unless you explicitly tells Excel to round the numbers.

Now if you don't want to show 0s when both cells are empty.....
In 2010 (sorry haven't done 2003 in a LONG time), I can do
=IF(AND(ISBLANK(C6),ISBLANK(C7)), "", SUM(C6:C7)/2)
Still that only places and empty string when both cells are blank and not a try empty cell... There is no way of getting around unless you get into VBA.