Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
IF L17 0.06 AND N17 3, then 2000, else 1500, for lookup xxxxxxxxxx
I need to compare two cells for each person to determine a raise. If they are x amount over a setpoint (L17 6%) and they have been evaluated as a 4 in N17, then give them $2000, else lookup their evaluation # and plug in the raise. examples L17 =11% and N17 =4 would equal $2000 L17 =11% and N17 =3 would equal $1500 L17 =3% and N17 =3 would equal Lookup eval 3 for xxxx L17 =4% and N17 =4 would equal Lookup eval 4 for xxx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do) | Excel Programming | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming |