help with PMT

technix · May 21st, 2002, 10:40 PM

I am new to excel, I am working on making a userform that has 1 text box to enter the sale price, 1 combo box to determine the duration and 1 combo box to select the rate, the data is placed into sheet 2 b20 = rate, b17 =duration, and a2=sale price. the PMT function appears to be a one time deal when done within a cell so if the data changes the cell doesnt update where the pmt formula is, I would like to know how to make it so that if I hit calculate it will calulate -pmt(b20/12,b17*12,a2) every time the calculate button is pushed. Again I am new so if you could help out by 1) giving me the code but 2) explain it so I do not have to ask again thus learning it as well.

Thank you

RET79 · May 21st, 2002, 11:17 PM

help with PMT? I think you are on the wrong forum

RET79

(sorry, bad joke but I couldn't resist it)

Russell · May 22nd, 2002, 01:01 AM

First question is:
Is your version set up to automatically calculate? Tools- Options-Calculate Tab and click on Automatic radio button.
Assuming this is OK the only time I could not get the function to automatically change was when the payments got beyond a certain number. The period was so long in relation to the amount, that the cost for extending the period ended up the same as the cost.

Russell

technix · May 22nd, 2002, 09:31 AM

I think that it is a settings issue as I cannot duplicate that error here in the office, only at home, So when I get home tonight I will check those options.

Thank you for the help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 10:40 PM	#1
technix Board Regular Join Date: May 2002 Location: Grand Rapids, MI Posts: 326	I am new to excel, I am working on making a userform that has 1 text box to enter the sale price, 1 combo box to determine the duration and 1 combo box to select the rate, the data is placed into sheet 2 b20 = rate, b17 =duration, and a2=sale price. the PMT function appears to be a one time deal when done within a cell so if the data changes the cell doesnt update where the pmt formula is, I would like to know how to make it so that if I hit calculate it will calulate -pmt(b20/12,b17*12,a2) every time the calculate button is pushed. Again I am new so if you could help out by 1) giving me the code but 2) explain it so I do not have to ask again thus learning it as well. Thank you

May 21st, 2002, 11:17 PM	#2
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	help with PMT? I think you are on the wrong forum RET79 (sorry, bad joke but I couldn't resist it)

May 22nd, 2002, 01:01 AM	#3
Russell New Member Join Date: Mar 2002 Posts: 39	First question is: Is your version set up to automatically calculate? Tools- Options-Calculate Tab and click on Automatic radio button. Assuming this is OK the only time I could not get the function to automatically change was when the payments got beyond a certain number. The period was so long in relation to the amount, that the cost for extending the period ended up the same as the cost. Russell

May 22nd, 2002, 09:31 AM	#4
technix Board Regular Join Date: May 2002 Location: Grand Rapids, MI Posts: 326	I think that it is a settings issue as I cannot duplicate that error here in the office, only at home, So when I get home tonight I will check those options. Thank you for the help