okay. i need help with a formula involving ranges. if i were to type in a number in d17, i need a correlating number to show up in f17. the ranges are 0-9= 6, 10-19=15, 20-29=19, 30-44=24, 45-59=27, 60-74=30 and 75 or more=34. also, if i type in dry hop into d17 i would like for f17 to show 0. so, if i were to type in 25 in d17, then i would like to see 19 in f17. i kind of have an idea on how to begin, it's just not working out. please, any help will be appreciated. thank you.