Posted by George Crowley on December 26, 2001 8:51 AM
I have a lookup table that increments in 0.5 units.
What I want to do is to get the average of 2 cells, and do a vlookup to get a value. My problem is that, my calculation requires that I round up to the next 0.5 unit and get the data from the table.
I have a fairly nasty looking nested IF statement that does not work if the value is less than X.5
If I have 1.7 I want to get the 33 value
if I have 1.5 I want to get the 22 value
If I have 1.3 I want to get the 22 value
If I have 0.99 I want to get the 1.0 value