| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statements in a Vlookup.
I have a Vlookup worksheet that the formula works. It is below
=PRODUCT(VLOOKUP($B3,'PTO '!$A$2:$BM$61,42),$C$3) This is for a PTO calculation by month. When an employee receives a raise I have added a current date column (E6) and new rate column (D6). The next month would be in the O1 position. I want the PTO to be calculated at the higher rate if there has been a salary increase. I have been trying to add the following to my formula and not having the right results. *if( E5<O1, D6, C6) Anyone have any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP and IF Statements | Excel Discussion (Misc queries) | |||
| If statements in Vlookup - can it be done? | Excel Discussion (Misc queries) | |||
| Help with Vlookup and If Statements | Excel Discussion (Misc queries) | |||
| can I use =if with vlookup statements | Excel Worksheet Functions | |||
| VLOOKUP statements | Excel Discussion (Misc queries) | |||
Threaded Mode
