Problem
If I have a table of four rows, the first and third ones are 0.5, and 1. the 0.5 and 1 have about 10 different results but there's a pattern so that the 0.5 is only associated with numbers below 0.6 and the 1 is associated with numbers above 0.61. How do I code this in excel/ vba so that when the user chooses values below 0.6 or above 0.61 the 0.5, and 1 are changed automatically.