| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a box where I can input data
Greetings:
I have a worksheet 'credit account' with cell G5 - Short term loan, J5 - Intermediate term loan and M5 - long term loan - this is where I enter the initial loan amount borrowed. After I enter the loan amount say, $200,000 I would like to be asked two questions: 1) What is the term of the loan? and 2) What is the interest on the loan? E6 & F6 would then contain the interest and principal on each loan payment throughout the year with the G6 having the remainder of the loan after each payment. I am working on getting this formula. I don't know how to write a formula to ask the two (2) questions mentioned above. Any help would be appreciated. -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 03 Trying to create input form | Excel Discussion (Misc queries) | |||
| Can I create an input bar? | Excel Worksheet Functions | |||
| create template with certain fields to input information only | Excel Worksheet Functions | |||
| How do I create a slider bar in Excel to control data input? | Charts and Charting in Excel | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
Linear Mode
