How to do a range in excel

[dyscjocki]

I need to have a formula to do this,
If cell "A1" is between 113 to 137 put the number 50 in cell A4 also if it is between 138 to 162 put the number 53 in cell A4.

Can this be done?

Thank you.

 

[facethegod]

Welcome,

In A4 try

=IF(OR(A1>162,A1<113),"",IF(MOD(A1,113)<=24,50,53))

 

[dave3009]

Welcome to the board

Perhaps something like

=LOOKUP(A1, {0,0;113,50;137,53})

in A4 might do the trick

HTH


Dave

EDIT:typo

 

[Yogi Anand]

I need to have a formula to do this,
If cell "A1" is between 113 to 137 put the number 50 in cell A4 also if it is between 138 to 162 put the number 53 in cell A4.

Can this be done?

Thank you.

Hi dyscjocki:

Welcome to MrExcel Board!

One way ...

y070908h1.xls
	A	B	C	D
1	114
2
3
4	50
5
Sheet22

formula in cell A4 is ... =VLOOKUP(A1,{0,"unknown";113,50;138,53;163,"unknown"},2)