Hi,

You've left out a lot of info - What is the formula you want to use with the
rounding formula? How are you rounding? In your example 877,394 is rounded
to 877,400
Is this rounded up to the nearest 10 or up to the nearest 100 or just to the
nearest 100. or is it rounded to the nearest 400?

To round to the nearest 10 you could choose

=ROUND(A1,-1)
or to the nearest 100
=ROUND(A1,-2)
or up to the next 100
=ROUNDUP(A1,-2)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"howdylee" wrote:

in a single cell, i need a formula for compounding inflation, and i need to
have that result to be rounded (example, one result from the formula is
$877,394) I want to have that number read $877,400, but within the same cell,
not in a different cell or column. how do i get both formulas in a single
cell? i've got the formulas for interest and for rounding but i can't get
them to work together in a cell, gives me a circular error.