Why not put ABS( ... ) around the formula you currently have, so it
will always show a positive value?

Hope this helps.

Pete

On Nov 30, 3:37 pm, wtrbb wrote:
Hi

am trying to calculate variances in a spreadsheet and am running across a
problem with the formula returning the wrong value for the cell, for instance
returning a negative variance when in fact it is a positive variance. i'v
added another hidden column with the absolute value and would like a formula
that would show the same value (positive or negative) for the percentage as
what is displayed in that adjacent cell - any ideas?
--
wtrbb