Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to write function to find max deviation from specific number .
how do I write a function to find the maximum deviation from a specific
number (say 25, for example) in a worksheet of numbers above and below 25 (say cells d7:r249, for example) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to write function to find max deviation from specific number .
Hi!
Try this: A1 = 25 =MAX(ABS(MAX(D7:R249)-A1),ABS(MIN(D7:R249)-A1)) Biff "barbdee" wrote in message ... how do I write a function to find the maximum deviation from a specific number (say 25, for example) in a worksheet of numbers above and below 25 (say cells d7:r249, for example) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to write function to find max deviation from specific number .
=MAX(ABS(D7:R249-25))
array entered (Ctrl-Shift-Enter) Jerry barbdee wrote: how do I write a function to find the maximum deviation from a specific number (say 25, for example) in a worksheet of numbers above and below 25 (say cells d7:r249, for example) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a "9" within a range using a function (T/F) | Excel Discussion (Misc queries) | |||
to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
How to use FV function to find a payment to reach a specific goal | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) |