Thank you all for your responses. I have thought about the ceiling function but the nominal values do not have constant increments. I made my example too simple. It would look more like:
Calc value = 2.5
Nominal value Size
1.8 A
3.2 B
4.5...
Hello:
I have a program that will give me a calculated value , and a table that lists nominal values vs. size. I need the ability to take my calculated value and find the appropiate size. However the LOOKUP function will give me the next smallest value, and what I need is the next higher...