Using IF + AND in Excel 2000

[exceldrivesmecrazy]

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

 

[Jacob Skaria]

Try..

=IF(AND(L17=11%,N17=4),2000,
IF(AND(L17=11%,N17=4),1500,
IF(AND(L17=3%,N17=3),VLOOKUP(N17,array,column,0),
IF(AND(L17=4%,N17=4),VLOOKUP(N17,array,column,0),""))))

If this post helps click Yes

 

[Forgone]

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 a4
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

This will work for your first example....

=IF(AND(L17>0.06,N17>3),3000,1500)

This would work for the first three.....
if you need to do more than those scenarios, a User Defined Function
with SELECT CASE might be better off.

=IF(AND(L17=11%,N17=4),2000,IF(AND(L17=11%,N17=3),1500,IF(AND
(L17=3%,N17=3),VLOOKUP(value,table,colno,FALSE),IF(AND
(L17=4%,N17=4),VLOOKUP(value,table,colno,FALSE),"ERROR"))))

 

[Jacob Skaria]

Correction.

=IF(AND(L17=11%,N17=4),2000,
IF(AND(L17=11%,N17=3),1500,
IF(AND(L17=3%,N17=3),VLOOKUP(N17,array,column,0),
IF(AND(L17=4%,N17=4),VLOOKUP(N17,array,column,0),"Conditions not met"))))

If this post helps click Yes