software

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.
--
help a friend help you

cell A1 should contain:

=ROUND(B1,2)quot;erniequot; wrote:

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

Cell A1 gt;gt;gt; =ROUND(B1,2)quot;erniequot; wrote:

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

lt;Toolsgt;lt;Optionsgt;
quot;Calculationquot; tab
Click quot;Precision as displayedquot;

Be careful, though, as you will lose all precision past what you display and
won't be able to get it back.
--
Regards,
Davequot;erniequot; wrote:

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

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

Two ways ....

Perhaps the easiest is to selected Tools gt; Options gt;
Calculations gt; quot;Precision as displayedquot;. 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).