Hi jewels,

I also noted that you have, in your argument, 2 separate conditions
that would yield the same value if true, if that is not just a typo,
then why do you need that?

Then simplify the formula I posted to:
=LOOKUP(G8,{0,0;163000,1000;187450,3000;244500,400 0})


or your formula, fixed:

=IF(G8244500,4000,IF(G8187450,3000,IF(G8=163000 ,1000,0)))


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