rounding

D

denhar

is there a way to have a column round automatically instead of having to
round onto another column? I don't want to add another column to just
be able to round.
 
R

Ragdyer

If the column contains formulas, the formulas can incorporate the Round()
function within themselves.

For example, if the formula is:

=A1*B1

it could be revised to:

=ROUND(A1*B1,2)

Is this what you're looking for?
 
R

Ragdyer

What formulas are you using to perform the rounding?

Just a thought ... Are you rounding ... OR ... formatting?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Ragdyer said:
If the column contains formulas, the formulas can incorporate the Round()
function within themselves.

For example, if the formula is:

=A1*B1

it could be revised to:

=ROUND(A1*B1,2)

Is this what you're looking for?
--
HTH,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -
Click to expand...
 
R

Ragdyer

Darn it - Wrong Thread !!!
Ragdyer said:
What formulas are you using to perform the rounding?

Just a thought ... Are you rounding ... OR ... formatting?
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -
!
Click to expand...
 
D

denhar

as dumb as this sounds, sometimes I really would like to be able to put
in $1.49 and it automatically change to $1 or $1.51 to $2. I have a
long list of numbers to enter from a bunch of sources so having to stop
and decipher takes too long. If I tell the column to not use decimal
places which accomplishes the same thing only it doesn't give me the
..00 that I need at the end.
 
R

Ron Coderre

If I understand you correctly, here are some thoughts . . .

First, use a custom format on your input cells:

Format>Cells>Number
Category: Custom
Type: 0".00"

That will make the numbers look like they are rounded to the nearest
digit, but will still display 2 decimal places.

However...If you the sum of those cells to behave as if all of the
values ARE rounded, you'll need a different kind of SUM function.
(Since they will contain the actual inputs (1.51 will look like 2.00,
but will still be 1.51)

Try this for your totals (assuming inputs are in A1:A10):
=SUMPRODUCT(ROUND(A1:A10,0))

That function sums the rounded numbers.

Does that help?

Ron
 
Top