#1
|
|||
|
|||
Help! figuring if statement with 2 vlookups excel 2013
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-
(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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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.
|
#4
|
||||
|
||||
__________________
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Figuring out an equation that has two different criteria | Lawryr | Excel | 3 | 10-06-2016 02:59 AM |
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet | Labyrinth | Word | 7 | 07-19-2016 01:35 PM |
Contacts Excel 2013 to Outlook 2013 | loulourose | Outlook | 2 | 03-07-2016 03:32 AM |
Please kindly help me out on how to link Excel 2013 file to another Excel 2013 file | samsnov | Excel | 5 | 09-29-2013 04:24 AM |
Mail merge will not format date field generated by Excel IF statement | borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |