Please give examples of your data, your formulas, what you require as results and what you get instead

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"wtrbb" wrote in message ...
| 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
|
|