populate a field based on a value

I want to know how to take a field with a value and apply it to fields with range. In this case if i had a value of 15 it would enter that value in this field
below. I tried an IF formula but it did not work.

range 31 to 40
range 21 to 30
range 11 to 20 15
range 1 to 10

Thanks for your help

We need to see what you're really trying to do. The example feels backwards to what is normally done. Do you have some real sample data showing what/where you're trying to accomplish this?

GO ADVANCED on your next post and click the paperclip to attach a workbook.

What I got so far is D14 is the value that will be entered. I want to populate the value from D14 to D9,D10,D11,D12,D13 if it falls within the range
I used this on D13 if(d14<650,d14,"") That works. Shown on Attachment
d9 if(d14>880,d14,"") That works

If you change d14 to 881 it will show you what I am trying to accomplish.
Just can't figure how to do the range?

Thanks for the help

Well, what you have seems slick enough. Now tell me what you want to happen OTHER than what is happening. If not in formulas, then with raw manual examples. I don't know what/where you're trying to CHANGE.

Wait, I think I figured it out. You're talking about the conditional formatting over the whole table range at the top coupled with more formulas? Maybe? Look this over in the top section.

Thanks JBeaucaire. That's exactly what I was looking for.