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
Hello Reddman,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Try using a vlookup formula based on a table you set up with the values. Much easier than individual formulas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks