mmm - if it were only that simple! sometimes the variance is negative, though
- i'm running into the problem with the formulas that are computing negatives
to negatives and pos/neg (where the variance should be a positive one, but
returns a negative value instead)

(b4-c4)/c4
--
wtrbb


"Pete_UK" wrote:

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