Thread: how to write function to find max deviation from specific number .
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default 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 With QuoteReply With Quote