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 sould round to .00

Thank you in advance for the assistance!

JohnB

By: John Borkowski

Leave a Reply

Your email address will not be published. Required fields are marked *