Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB syntax problem with referencing another tab | Excel Discussion (Misc queries) | |||
Referencing Date problem | Excel Discussion (Misc queries) | |||
workbook referencing problem | Excel Worksheet Functions | |||
Problem Referencing Multiple Lists | Excel Worksheet Functions | |||
Referencing Problem | Excel Discussion (Misc queries) |