Hi

I a drop down box with the following values that the user can selet

1-4
5-8
9-12

In the next column I have a formula that converts the above into a number -
so it can be used in a formula.

=IF(H5= "1-4",4)

How do I add to the above formula a condition that says if "5-8" is entered
in H5 then the cell = 8 and if "9-12" is entered the cell = 12.

I know how to right individual bits - but not combine them together.

I hope this makes sense.

Cheers,

Phil