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

Using IF + AND in Excel 2000
 

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
---------------
Jacob Skaria


"exceldrivesmecrazy" wrote:

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

Using IF + AND in Excel 2000
 

On Sep 14, 11:36*am, exceldrivesmecrazy
wrote:
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

This will work for your first example....

=IF(AND(L170.06,N173),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),"E RROR"))))

Using IF + AND in Excel 2000
 

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
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"exceldrivesmecrazy" wrote:

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