| Home |
| Search |
| Today's Posts |
|
#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) |
| 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) | |||
Threaded Mode
