View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
exceldrivesmecrazy exceldrivesmecrazy is offline
external usenet poster
 
Posts: 1
Default Using IF + AND in Excel 2000

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