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

You format the cell to 2 decimal places with the format dialog box.