Thank you soo much. I am just learning all these formulas - yeah one of the
bonuses is the same amount so I guess I really don't need the two numbers in
there.

I really appreciate all the help.

Do you know of a good place to learn about all different functions = I live
in Massachusetts.

"Vito" wrote:


Hi,

Try this instead:

I have assumed anything less than 163,000 would result in 0:

=LOOKUP(G8,{0,0;163000,1000;187450,3000;23412,3000 ;244500,4000})


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=491796