View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Having problem with referencing

These are the actual values in a portion of a table; If cell "T1" says
".12" I need it to first recognize the closest value, being between 0.1179 &
0.1217. Second, since it is closer to 0.1217 it would return the value ".31".
How can this be accomplished please?

0.00 (0.01) 0.02 0.03
0.0 0.0000 0.0040 0.0080 0.0120
0.1 0.0398 0.0438 0.0478 0.0517
0.2 0.0793 0.0832 0.0871 0.0910
(0.3) 0.1179 (0.1217) 0.1255 0.1293
0.4 0.1554 0.1591 0.1628 0.1664
0.5 0.1915 0.1950 0.1985 0.2019
0.6 0.2257 0.2291 0.2324 0.2357
0.7 0.2580 0.2611 0.2642 0.2673
0.8 0.2881 0.2910 0.2939 0.2967
0.9 0.3159 0.3186 0.3212 0.3238
1.0 0.3413 0.3438 0.3461 0.3485
1.1 0.3643 0.3665 0.3686 0.3708

--
Thank you!