Thread: Trying to display the number between two numbers closest to another value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Trying to display the number between two numbers closest to anothe
Assuming your data in ascending order

=LOOKUP(60,A1:A3)


" wrote:

I want to display the number closest in value, but not great than 60.

For example:

29
39
64

the number displayed from that range would be 39


Reply With QuoteReply With Quote