Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel Formula Nominal and APY (https://www.askmehelpdesk.com/showthread.php?t=146739)

  • Oct 30, 2007, 12:50 PM
    mfischman
    Excel Formula Nominal and APY
    I have a rounding issue in Excel. If I enter a APY Rate, for example 3.75 and then calculate the nominal, I get a long decimal of 3.68705 . I need to find a way to cut the decimanl to 2 places, and then still be able to use a formula to get back ot the same 3.75 APY. The problem is if I use the Fix or Round formula, I get a rounded Nominal and then a new APY of 3.76

    Please help. Thanks
  • Oct 30, 2007, 09:00 PM
    Duane in Japan
    You format the cell to 2 decimal places with the format dialog box.

    • All times are GMT -7. The time now is 03:45 PM.