Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following example
A column with number of days: days 3 7 31 61 91 181 271 365 Now i have a certain formula which returns to me a number of days - for example 21. 21 belongs in between 7 and 31 in the days column. I am looking for a formulas that would return this high and low number of the interval in which my number belongs to: - for 21, the solution should be 7 and 32, - for 183, the solution should be 181 and 271 - and if the number equals one of the numbers in the column the solution should be the exact number if i have 31 the solution should be 31 is there a way to do this. thanx for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return a High Number | Excel Worksheet Functions | |||
formula to throw out high number and low number | Excel Worksheet Functions | |||
change the color of a number when it gets too high | Excel Discussion (Misc queries) | |||
Searching a Range for a number over 40 | Excel Worksheet Functions | |||
Searching and returning row number of a value | Excel Worksheet Functions |