Excel Rounding
Posted by D.Hamilton on January 23, 2002 7:33 PM
I understand that Excel calculates more decimal places
than the number formatted in a cell.
I have been unable to properly use the round function
when calculating a value in a particular cell that I
need to copy to other cells.
The number argument is not clear when applying to a cell because I am getting the circular reference error
message.
Example: =.15*(c27-53.85-124) Result: 33.3225
I need to round the result when calculating in cell d27.
I am making several calculations and need all items to
add down and accross. I am out pennies and I feel sure
this is a result of improper handling of the Round
Function.
Can you give me a proper example of the above?
Posted by on January 23, 2002 8:08 PM
=round(.15*(c27-53.85-124),2) (NT)
Posted by Richard S on January 23, 2002 8:17 PM
Precision as Displayed
Tools menu, options, calculation tab, click precision as displayed.
Richard
Posted by Aladin Akyurek on January 24, 2002 4:43 AM
> I am making several calculations and need all items to
> add down and accross. I am out pennies and I feel sure
> this is a result of improper handling of the Round
> Function.
If you want to copy a formula across, you have to know what must stay the same and what must change. When you want to copy down, again you need to consider what needs to change and what must stay the same. Look in the Help in order to understand relative and absolute addressing & copying.
You had in D27 initially =.15*(400-53.85-124), 400 being in C27.
Now you have (my doing I guess): =.15*(c27-53.85-124)
If you copy =.15*(c27-53.85-124) across, it will become: =.15*(D27-53.85-124)
If you copy =.15*(c27-53.85-124) own, it will become: =.15*(c28-53.85-124)
BTW, if you have in D27
=ROUND(.15*(c27-53.85-124),2)
you'll see a result in D27 rounded to decimal places. Also, have a look at ROUND in the Help.
In a long chain of computations, it is important to determine when to round. It's possible that you need to round the end result, not the intermediate steps.
PS. There is absolutely no need to start another thread on the same question.
=========
