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)

Hi!

Try this:

A1 = 25

=MAX(ABS(MAX(D7:R249)-A1),ABS(MIN(D7:R249)-A1))

Biff

"barbdee" <[email protected]> wrote in message
news:[email protected]...
> 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)

=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)