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.