Excel Formula Nominal and APY

mfischman · #1 Oct 30, 2007, 12:50 PM

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

Duane in Japan · Oct 30, 2007, 09:00 PM

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



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!