Hello, I've been trying to nest an IF statement with VLOOKUP. My problem is....

Sales

$4000Hours Worked

8On a master sheet.....

Base Pay

$23.50Commission Rate

0.030Would someone help me make a nested statement that will grant this person 0.030 commission and calculate the total commission if he/she exceeds a $200 per hour quota?

My prof told me to look at Excel help, for help. I'm lost so any guidance would be greatly appreciated!

If you followed your prof's advice and used the Excel Help files, you'd see that VLOOKUP usually involves a lookup_valueand atable_array.In other words, something to look up and a table (or list) of data in which to look it up in.I don't see anything in your example data that requires a VLOOKUP. Are you sure you have told us everything we need to know to point you in the right direction?

BTW...since this is homework, we'll try to nudge you in the right direction without giving you a direct answer.

IF statements with Vlookup. Where's the nudge?

pappyP, Perhaps you missed my point.

I don't see anything in the OP's example data or question that shows a need for a VLOOKUP. Before I nudge him in the wrong direction, I'd like a little more info.

Feel free to give him a nudge based on the subject line. I'd prefer to get a better understanding of why he mentioned VLOOKUP in the first place.

Hi PappyP, Like DerbyDad03, I do not see anything in the information provided that would require the use of VLOOKUP.

Your problem basically requires two calculations.

1. The rate of making sales

2. The rate of pay both with and without commissionUse an IF statement to decide whether to pay base pay only or base pay plus commission.

Suggesting that VLOOKUP() is

notrequired was a pretty good nudge, unless of course you haven't provided all the relevant information.Regards

Hey, pappyP... When I responded, I didn't realize that you were the OP. I didn't check the username...I just assumed it was someone else. Sorry!

What I said about VLOOKUP still stands, but I would have said it differently had I realized that it was you that responded.

That said, we'd like to help, so maybe we're just missing a piece of information or two that explains what you are trying to do.

For example, if an IF with VLOOKUP

isrequired, tells us what you are looking up and what the IF criteria and results should be.If you just want to see what an IF and VLOOKUP formula might look like, Google IF VLOOKUP for lots of different combinations/examples. Perhaps that will get you started.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History