| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to display the number between two numbers closest to another value
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to display the number between two numbers closest to another value
Try this array formula** :
=MAX(IF(A1:A10<=60,A1:A10)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP wrote in message ps.com... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
| How can i round a number to closest tenth number? | Excel Worksheet Functions | |||
| find closest match to a reference number in a row of numbers | Excel Discussion (Misc queries) | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
| Closest number match help ... | Excel Worksheet Functions | |||
Linear Mode
