IF (And) forms excel

[dankri92]

How do I make the form if:

X = 1-50 then 81

X = 51-100 then 108

X = 101-200 then 158

I can only do the first one


Please help.


//: Dan

 

[mole999]

untested as I don't know what cell you are looking at
=IF(AND(cell>=101,Cell<=200,158),IF(AND(cell>=51,Cell<=100,108),IF(AND(cell>=1,Cell<=50),81,"No Match)

 

[Caribeiro77]

Try:

Book1
	A
1	51
2
3
4	108
Sheet1

Cell Formulas
Range	Formula
A4	=VLOOKUP(A1,{0,81;51,108;101,158},2)

 

[dankri92]

It is not working..

I need to find out how to:

If X is a number between 1 and 50 then The number has to be 81

And if X is between 51 and 100 then The number has to be 108.


So x has to be a cell, where i can chance The number.

 

[FryGirl]

I think this should work also

=IFERROR(LOOKUP(A1,{1,51,101},{81,108,158}),"")

 

[mole999]

It is not working..

I need to find out how to:

If X is a number between 1 and 50 then The number has to be 81

And if X is between 51 and 100 then The number has to be 108.


So x has to be a cell, where i can chance The number.

where is the cell you are looking at to put your number, because unless you tell us, or you are extremely lucky, what does work, won't