Ive got the first vlookup complete, cant figure out the 2nd, maybe 3rd vlookup? Im trying to figure up the commission for my associates , screenshots, instructions below-

1. calculate commission. Commission is only paid if the Quota is met. The formula used for Commission calculation will be an IF statement that contains two VLOOKUP commands. The following is the logic for the commission formula in English. This must be converted to commands for Excel. You will use IF statement with VLOOKUPS to find data in the table. Suggestion: first create each Vlookup separately to get format correct and verified. Build your full IF () statement from known-good functions, after verifying each individually.

(Note wage sheet at bottom)
Commission Calculation:
IF the daily sales are greater than (Hours Worked times Hourly Quota) [from table] then
TRUE = Calculate commission using this formula:
(Daily sales minus the (Hours Worked times Hourly Quota)) multiplied by the commission rate [from table]
FALSE (i.e. not true) = zero (0) commission

Hi
is this some kind of homework?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

No, a friends business, he's asking me to help him get this going, I've found some instructions (how-to's) but just can't seem to get this formula worked out.

Duplicate thread. https://www.msofficeforums.com/excel...ification.html

Thread closed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post