Enter a number depending on the value of the adjacent cell witjin ranges

Hi folks,

This seems like a ridiculously easy thing to do - but I can't seem to work it out !

I want Excel to enter a number for me in a cell adjacent to another cell which has a value that can fall within several ranges.

For example :-

if the value in cell D6 is between 8 and 16, I want Excel to place a 28 in cell C6
if the value in cell D7 is between 128 and 256, I want Excel to place a 24 in cell C7
if the value in cell D8 is between 256 and 512 I want Excel to place a 23 in cell C8
if the value in cell D9 is between 512 and 1024, I want Excel to place a 22 in cell C9
if the value in cell D10 is between 1024 and 2048, I want Excel to place a 21 in cell C10

Any help you can give me would be greatly appreciated.

Thanks and regards,

Malcolm.

Can you clarify the ranges?
1 range is missing, and the others overlap each other..

What about between 16 and 128 ??
What about less than 8, or greater than 2048 ?

And say a cell is exactly 256, should that be 24 or 23 ??
Same for 512 and 1024

Hi Jonmo1,

Thanks for your help !

I was going to keep it simple and then modify what someone sent me, but as you ask .....

>=2 and <4 I would want a 30
>=4 and <8 I would want a 29
>=8 and <16 I would want a 28
>=16 and <32 I would want a 27
>=32 and <64 I would want a 26
>=64 and <128 I would want a 25
>=128 and <256 I would want a 24
>=256 and <512 I would want a 23
>=512 and <1024 I would want a 22

Thanks agin,

Malcolm.

Try this
=31-INT(LOG(D6,2))
and copy down

I was going to suggest
=LOOKUP(D6,{0,2,4,8,16,32,64,128,256,512,1024},{"",30,29,28,27,26,25,24,23,22,""})

But Jose's is much nicer...

Well thank you very much to you both for your kind help.

I am truly grateful for all the helpful folks on this forum.

Have a great day.

Thanks,

Malcolm.