Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for a # in a column of #'s that's closest to a certain val
I'm looking for a function or formula in Excel that will find a number in a
range of numbers that is closest to a specified number. Example: I have a column of 7 cells that contain cummulative percentages from 0 - 100. It will always be theses same cells, but will have varying percent values depending on other calculations. I need to find the first number that's closest to and below 10. I also need to find the first number that's closest to and above 10. I need this for 3 other values (40, 50, & 90)as well, but if I can get an example of a formula, I could probably go from there. Thanks in advance for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula for a column | Excel Discussion (Misc queries) |