Help showing a form of a range.

**fleetwood417** · 11-09-2012, 08:41 PM

For my work, I'm creating a payment plan calculator. The sheet uses the payment formula, and based on a specific interest rate, current loan balance, and duration, it calculates monthly payments for the customer. What I'm looking for is a way to add a range to this. For example, based on my current sheet, let's say the customer's regular payment comes out to be 246.12 a month. I want a formula that will calculate an amount that Is +/- "x" amount of dollars for the given monthly payment. So, let's say my threshold is +/- $50.00; I'd have cell A giving the montly payment of 246.12, and then cell B would should something like 196.12-296.12. Any thoughts?

**jeffreybrown** · 11-09-2012, 08:44 PM

You could do this with the threshold in a cell, C1

=A1-C1& " - " &A1+C1

**fleetwood417** · 11-09-2012, 08:52 PM

Hey, thank you very much. It worked right away. I have one more question though. I formatted the cells for currency with two decimal places, but for some reason it's still producing results with 12 decimal places. Any idea why??