Help with multiple if statements

[Jmontet]

Hey there i know there is something simple I am missing. I am trying to set up a formula that will pull data from a cell based on where another cell falls in line numerically
A B C
1 <2999 <9999 <250000
2 10 20 30

So basically if the number in a cell i specify lets say F49 is less than 2999 i need it to display the value in cell A2, if it is between 2999 and 9999 i need it show the value in cell B2, and if over 99999 it displays value of C2

 

[Fluff]

Hia & welcome to the board
How about this
=IF(F49<2999,A2,IF(AND(F49>=2999,F49<=9999),B2,C2))

 

[Dave Patton]

Excel 2010
	A	B	C
1	0	2999	9999
2	10	20	30
3
4	20	20
5
6b

Cell Formulas
Range	Formula
A4	=LOOKUP(F49,A1:C1,A2:C2)
B4	=INDEX(A2:C2,MATCH(F49,A1:C1,1))

 

[Jmontet]

Hia & welcome to the board
How about this
=IF(F49<2999,A2,IF(AND(F49>=2999,F49<=9999),B2,C2))

It worked. Thanks Fluff. I new it was simple. I was overthinking the dang thing

 

[Fluff]

Glad to help & thanks for the feedback