Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help please
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=502952 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help please
pooh
Don't know how far ect.(sic) extends, but here is a formula you can adjust. =LOOKUP(A1,{0,79,201},{1,2,3}) entered in B1 Drag/copy down B as far as you wish. Gord Dibben MS Excel MVP On Thu, 19 Jan 2006 10:55:31 -0600, darkbearpooh1 wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help please
That works perfect Thanks So Much! I have more work To do to the worksheet so i might be posting again shortly thanks!!!!! -- darkbearpooh1 ------------------------------------------------------------------------ darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640 View this thread: http://www.excelforum.com/showthread...hreadid=502952 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|