98.3 % recommend us More live stats... RSS feeds What's this? All hints and tips: Only Excel hints and tips:

Hints and tips home » Excel hints and tips » Creating a range of monthly payments as text

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help


3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

Added by Tom on 23rd November 2006

More Excel hints and tips, like:

• Manually wrapping text
• Bracketed negative numbers
• Moving between split pane sections in a spreadsheet