Hi!

If the value is negative it will automatically be returned
as negative:

-100

If you want the returned value to always be positive just
put your formula inside an ABS (absolute value) function:

=ABS(SUM(DCAC!B4,'787 '!B4,'FI Hub'!B4,M2A!B4)-Master!B3)

Biff

-----Original Message-----
I have a formula that is adding variuos cell values from
different pages. It
then goes and subtract this value from another value on
another page. it is
written like this: =SUM(DCAC!B4,'787 '!B4,'FI Hub'!B4,M2A!
B4)-Master!B3

What I need to find out is how to include the formula so
that if the
returned value is negative it displays this way or
positive. I believe it
would be the SIGN function? I am not sure and I can not
figure out how to
include it in my formula.
Thanks
.