I'm not sure what you are asking, but if you want the number with the
largest magnitude (regardless of sign), then you can use this:

=MAX(A1:A20,ABS(MIN(A1:A20))

Hope this helps.

Pete

On Apr 23, 4:10*pm, Robin wrote:
I have a worksheet in which i must subtract cells to show a variance. However
I would like to created a chart to dispay the values. The problem is when
subtracting the values there sometimes may be instances of a negative value.
This is not that it may not be correct for use in some charting circumstances
it would be correct; however when the chart is used to dispay a maximum
variance a positive 12 should not be max and a -58 should not be min. The
absolute value of 58 should be the maximum variance.

I would appreciate your help,

Sincerely
Robin Scott