I am entering projections on a worksheet
example $100 in cell 1 $200 in cell 2 ect.

I have a chart that states the criteria needed for each amount entered
example $0-$78 = 1
$79-200= 2
ect ect.

i need a formula where i can enter the projections in one cell and
based on those projections and the chart give the number for those is
this possible ?


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=502953