how to create an absolute value

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

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
 
Hi
Let's say your negative number is in A1 in B1 enter
=ABS(A1)

If this was helpful please say yes, thanks
 
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
 
Back
Top