Posts by JubberB

    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