formula to drive plus or minus as operator
 

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?

formula to drive plus or minus as operator
 

=IF(B10, A1-B1, A1+B1)
--
Gary''s Student - gsnu200797

formula to drive plus or minus as operator
 

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

On Aug 5, 11:22*pm, Newsgal wrote:
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?

formula to drive plus or minus as operator
 

=A1-ABS(B1)

--


Regards,


Peo Sjoblom

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

formula to drive plus or minus as operator
 

Thanks, that should do it!

"Gary''s Student" wrote:

=IF(B10, A1-B1, A1+B1)
--
Gary''s Student - gsnu200797