how to create an absolute value

[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

 

[Eduardo]

Hi
Let's say your negative number is in A1 in B1 enter
=ABS(A1)

If this was helpful please say yes, thanks

 

[Pete_UK]

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

 

[Robin]

Yes, Thank you Eduardo. it was helpful. How do you get it to display positive
or negaive.