Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel range formulas
I need a formula that will allow me to see how far below or above a set range
my data point is. If this isnt clear ill draw it out. I have a return of 8 and i have a range of 10 to 17. I want a formula that will tell me that is -2 and vice versa if the data point was above the range come back as a positive number. Is there a formula that will evaluate all of this on its own? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel range formulas
=IF(A1<10,A1-10,IF(A117,A1-17,"within a set range"))
"kennedy.matt" wrote: I need a formula that will allow me to see how far below or above a set range my data point is. If this isnt clear ill draw it out. I have a return of 8 and i have a range of 10 to 17. I want a formula that will tell me that is -2 and vice versa if the data point was above the range come back as a positive number. Is there a formula that will evaluate all of this on its own? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas in a range of cells | Excel Worksheet Functions | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
How do you set up range names, name formulas | Excel Worksheet Functions | |||
how can i use same range of data for different formulas in excel? | Excel Discussion (Misc queries) | |||
Excel copy formulas using non contiguous range | Excel Discussion (Misc queries) |