I have over 200 combinations of data that I need to equate to another number.
ie. each one of these numbers left of the equal sign can equate to a number on the right. anything between .57 and .606 equals 14. Anything between .645 and .681 would be 14.2.
I have over 200 sets like this. I can see the formula becoming very long. Any help to reduce the length of formula??
0.570= 14.0
0.607= 14.1
0.645= 14.2
0.682= 14.3
0.719= 14.4
0.757= 14.5
0.794= 14.6
0.831= 14.7
0.868= 14.8
0.906= 14.9
Bookmarks