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