Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a question about a project that I don't understand, if anyone
could help that would be awesome! Here is the question: Consultants who work on a project also receive a bonus if the fees exceed estimates, otherwise the consultant received no bonus. Create one formula that calculates the bonus by referencing the appropriate bonus rate in the table given by the number of hours the consultant worked. Does this make sense to anyone? I really need help. I fthis requires a vlookup, can someone help me set it up? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |