formula to drive plus or minus as operator

[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?

 

[Gary''s Student]

=IF(B1>0, A1-B1, A1+B1)

 

[Pete_UK]

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

 

[Peo Sjoblom]

=A1-ABS(B1)

--


Regards,


Peo Sjoblom

 

[Newsgal]

Thanks, that should do it!