Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel rounding (https://www.askmehelpdesk.com/showthread.php?t=37944)

  • Oct 19, 2006, 07:21 AM
    ELATHAM
    Excel rounding
    ELATHAM
    How do I keep Excel from Rounding off. When it rounds off it makes my final totals wrong.

    My figures need to balance right to the penny.

    Thank you,

    Estrella
  • Oct 19, 2006, 07:32 AM
    ScottGem
    Are you formatting the cells for a specific number of decimal places or as currency? Normally Excel doesn't round the value that's in the cell, unless you use the Round function. However, if you format the cell to display a limited number of decimal places, it will round the display but toals will be correct. For example you have these three numbers and their 2 decimal display:

    12.3478 12.35
    15.1232 15.12
    17.6759 17.68

    However, they would total to 45.1469 which would display as 45.15.

  • All times are GMT -7. The time now is 03:46 AM.