numbers dont round up

E

ernie

my numbers do not round up... lets say i have dfferent cells get values based
on different calculation.. ex: A1 get its value from B1. B1=2.7169. when i
format A1 to 2 decimal places it show 2.72. now if i multiply A1 by 3 in
another cell, instead of showing 8.16 (2.72*3), it shows 8.15 (2.7169*3). i
need the cells to calculate based on whats in it. how to i get it to
calculate with 2.72 instead of 2.7169???

thanks in advance.
 
D

David Billigmeier

<Tools><Options>
"Calculation" tab
Click "Precision as displayed"

Be careful, though, as you will lose all precision past what you display and
won't be able to get it back.
 
J

joeu2004

ernie said:
A1 get its value from B1. B1=2.7169. when i format A1
to 2 decimal places it show 2.72. now if i multiply A1 by
3 in another cell, instead of showing 8.16 (2.72*3), it
shows 8.15 (2.7169*3). i need the cells to calculate
based on whats in it. how to i get it to calculate with
2.72 instead of 2.7169???
Click to expand...

Two ways ....

Perhaps the easiest is to selected Tools > Options >
Calculations > "Precision as displayed". But I would not
do that myself because of unexpected consequences.
Sometimes, you want the hidden extra precision to work
for you.

The alternative is to use the ROUND(), ROUNDUP() and
ROUNDDOWN() functions where you want them. For
example, change the formula in A1 to ROUND(B1,2).
 
Top