USING ROUND UP

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

When I use round up,2 - I get the figure I want. For
example 2.344 gets me 2.34 and 2.346 gets me 2.35.
However when I reference this cell the "unrounded figure
is used. What do I have to do to make the rounded figure
from there on out use. I use this with money and it keeps
throwing me off a penny here and there.

Thanks, Bill
 
Bill,

Rounding does not change the presentation , it alters the value. So if A1
holds 2.346, and B1 =ROUNDUP(A1,2), B1 will hold 2.35, not 2.346 showing as
2.35. Then when you use B1 elsewhere it will be the value 2.25.

You aren't still referring to the original cell are you, like A1 here?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Assume you have a formula in cell C9

=A9/B9

you can put this inside your round formula

=round(if(B9<>0,A9/B9,0),2)

then if you refer to C9, you will get the value of the rounded result.
 
-----Original Message-----
Bill,

Rounding does not change the presentation , it alters the value. So if A1
holds 2.346, and B1 =ROUNDUP(A1,2), B1 will hold 2.35, not 2.346 showing as
2.35. Then when you use B1 elsewhere it will be the value 2.25.

You aren't still referring to the original cell are you, like A1 here?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)


Bob,
Click to expand...
I am taking a salary, say $35,000 divided by a constant of
2080 to get an hourly wage.

A B C
1 35000 2080 =ROUNDUP(A1/B1,2)The above example results in $16.8269.... and shows as
$16.83. Now when I refer to cell c1 and multiply it by a
large enough figure, do not get $16.83 times that figure.
Sometimes it comes up a little short and I have been
attribiuting this to the unround number being used.
 
Bill,

When you use C1 with small values, are you getting correct results? If so,
the large numbers errors are probably errors in the floating point
arithmetic. This article on Chip Pearson's site might help explain it
http://cpearson.com/excel/rounding.htm


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top