First Bank of Missouri = H.W.
Hello everyone,
I have this H.W. for Excel that made me crazy I don't know anymore how to do it and I'm must turn it in tomorrow before 9:00 AM - Monday. That is not all
I have also a test at the H.W. tomorrow, so please anyone help me if you know it I will be grateful for that.
All the H.W. things are attached and My Work, I tried my best but I don't think it is right.
Thank you again.
You are supposed to use VLOOKUP formulas...
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
1. ... to find the interest rate ...:
Lookup value: "loan term"
table array: the loan table
col_index: the column number in the table where the interest rates are
range_lookup: "false" (in most cases)
2. ... the down payment uses VLOOKUP to find the required down payment rate, which you use to calculate via formula, the required down payment amount
--------------------------
Please put VLOOKUP formulas in D6:D14 / E6:E14 and post the amended worksheet
---
Ben Van Johnson
I did not understand how to do it.
sorry for asking you this but could you please do the steps you told me in one of the files
that I upload, so I can understand.
thank for your help. I appreciate your help
Last edited by Paul; 02-06-2012 at 04:26 PM.
In D6,
=VLOOKUP(C6,A$17:C$19,2,0)
Then copy D6, then paste down. Also format the cell as %.
E6,
=VLOOKUP(C6,A$17:C$19,3,0)*B6
Then copy E6, then paste down.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
Thank you for your help I appreciate it. I only need
one last thing and I'm so sorry for being so rude
for asking to much question. but I only the formal
for Monthly Payment, and I understand if
will not help me and also I'm thankful for
the help you gave me.
Last edited by Paul; 02-06-2012 at 04:26 PM.
You really need to try! Lookup PMT in Help. I'm still waiting to see your work.... it's not hard.
Note: If you are in school/college, turning in some one else's work is called plagiarism and it can get you kicked out of school if you are found out!!
Please try the PMT function yourself...
Last edited by protonLeah; 02-05-2012 at 07:55 PM.
---
Ben Van Johnson
I got it thank so much for your help
=PMT($D$6:$D$14/$B$3,$C$6:$C$14*$B$3,-$F$6:$F$14)
Last edited by Paul; 02-06-2012 at 04:27 PM.
Mind if I see your loan stats formulas?
---
Ben Van Johnson
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks