 # Add Rounding to an Existing Formula

• I have a cell with a simple formula and I would like to round the result in the same formula in the same result cell.

Example: =SUM(K16*1.03) with the result in L16. What I would like to do is if the result that will populate L16 ends in .01 to .04 the result will round down to .00; if the result that will populate L16 ends in .05 to .09 the result will round up to .10. I do not want to add another column to the spreadsheet.

So it would look like this:

K16 = 57.75

L16 =SUM(K16*1.03)

L16 = 59.48

Since L16 ends in .48 that should be .50

If L16 ended in .03 it should round to .00

Alternatively, we can round to "round Numbers: such as \$X.00, \$X.25, \$X.50, \$X.75).

Thank you in advance for the assistance!

JohnB

• Does this work?

=ROUND(SUM(K16*1.03),1)

Where there is a will there are many ways. Finding one that works for you is the challenge!

• Yes, we're close. Thanks for the reply!
How about this: We want to round to the nearest .00, .25, .50, or .75. Can that be done easily?
Thanks again!
JohnB

• BINGO! Thank you both! Much appreciated.

• By the way, as you may have noticed with the last suggestion the SUM() is redundant in this context.

So my suggestion should really have been:

=ROUND(K16*1.03,1)

Where there is a will there are many ways. Finding one that works for you is the challenge!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!