In cell J5, create a VLOOKUP function that returns the salesperson commission that corresponds with the base cost of the car (in F5). Use the range $C$24:$D$28 as the Lookup Table, and return the commission rate from Column 2.
In cell J5, create a VLOOKUP function that returns the salesperson commission that corresponds with the base cost of the car (in F5). Use the range $C$24:$D$28 as the Lookup Table, and return the commission rate from Column 2.
This sounds like homework to me - check out the Forum Rules on what they say about that.
Pete
okay and can u help me with this problem it asked: In cell I5, enter a function to calculate a monthly payment for buyers. The function will refer to the annual interest rate (in D21) divided by 12, a loan term of 48 months, and the total cost of the car (in H5). Refer to the annual interest rate (D21) as an absolute cell reference. Copy the function down to cells I6: I16. with the same spreedsheet
I assumed I would put in =$d$21/12+H5 but the ammount is not a monthly payment so I tried =$d$21/12*H5 but im not sure if it is correct
lol did you even bother to read what Pete said??
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
the question i asked him after does not deal with vlookup its just creating a formula to show the monthly costs by dividing the interest rate by 12 and what is in H5, I just want to know if the formula i created was correct or not.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-form...-payments.html
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks