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

"Eduardo" wrote:

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

If this was helpful please say yes, thanks

"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