| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the number?
Does anyone have any suggestions on how to find the number?
Example 1: There is a number 19650 in cell A1, I would like to fit this number below 2025, therefore, it should return 1965 in cell B1. Example 2: There is a number 25624 in cell A1, I would like to fit this number below 2025, therefore, it should return 256 in cell B1. Example 3: There is a number 10.065 in cell A1, I would like to fit this number below 2025, therefore, it should return 1006 in cell B1. Does anyone have any suggestions on how to set the formula to do it? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
| Need Cells.find to find first number in a row which is 8000 | Excel Discussion (Misc queries) | |||
| find the frequency a number appears with another number within a s | Excel Worksheet Functions | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| How do I find the total number of the same number/letter in a row | Excel Discussion (Misc queries) | |||
Threaded Mode
