excel spreadsheet for flange size selection

I have a spreadsheet with a drop down cell (B7) which has 4 values, each of which appear in a table on separate cells (H3,H4,H5,H6), values are 1.2.3.4 (covered by the formula below
=IF(B7=H3,"1", IF(B7=H4,"2", IF(B7=H5,"3",IF(B7=H6,"4"))))

Then I need the user to input in a separate cell a dimension that relates to one of the "H" values, ie 1,2,3 or 4. where each "H" value has a range of sizes associated to it. ie 1 = >.5 but <=2, and 2 = >2 but <4, and 3 = >4 but <6 and 4 = >6 but <10 I want to add a separate cell with a formula that basically says:

If cell B7 = 2 then (the dimension within that new cell C20 for example) the input dimension can only be within that specific range (in this case greater than (>) 2 but less than (<) 4) (so the formula looks to see the value in B7 drop down choice and retus either ("Okay" for an input value between 2 to 4 or a "Fail" retu if the value is outwith that range ie 4.2). To guide the user to input a relevant (to the B7 value) dimension.

Recent Questions...