Hi all,

I need a little help with a formula - if it can be done ...
Below is a table that shows kw units and cost. A calculation is
performed on information user supplies and the result can be anywhere
between 0.0 and 3.
If for instance the result returns 1.3, can I get a formula to check is
1.3 is there and if not select the next nearest 1 higher ie 1.5


A B
0.5 51
0.75 51
1 62
1.25 62
1.5 63
2 63
2.25 63
2.5 64
3 64


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=278328