formula to drive plus or minus as operator

  • Thread starter Thread starter Newsgal
  • Start date Start date
N

Newsgal

We have a standard formula to show the variance of 2 totals (A1-B1 =
Variance). However, it only works when B1 is a positive number. Is there a
formula that changes the operator to a plus when B1 is a negative nubmer?
 
Strictly speaking that formula gives you the difference, not the
variance. If you always want a positive difference then you can use
the ABS function:

=ABS(A1-B1)

Or you might mean something like this:

=A1-ABS(B1)

Hope this helps.

Pete
 
Back
Top