LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to determine the closed value?

There is a number 14 in cell A1, and there is a list of number under column B,
for example,
8, 11, 16, 18, 21
I would like to determine the value within the list, which is closest to 14,
and 16 should be returned in cell A2.

8, 12, 16, 18, 21
I would like to determine the value within the list, which is closest to 14,
and because 14 is between 12 and 16, then I prefer the larger number, and 16
should be returned in cell A2.

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup From Closed Worksheet Jeremy Excel Discussion (Misc queries) 5 April 8th 08 06:45 PM
Looking up information in closed files [email protected] Excel Discussion (Misc queries) 0 January 12th 07 11:07 AM
Closed Macros still visible Gizmo63 Excel Discussion (Misc queries) 2 January 2nd 07 12:13 PM
Linking Files that are closed [email protected] Excel Discussion (Misc queries) 2 October 16th 06 05:16 PM
Value from a closed workbook Anthony Slater Excel Discussion (Misc queries) 5 May 17th 05 09:49 AM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"