One approach is to type negative 1 "-1" without the quotes somewhere in your
worksheet. Copy that cell, then highlight your entire result range, paste
special multiply.

H.T.H.
--
when u change the way u look @ things, the things u look at change.


"Molly" wrote:

I have two long formulas each of which produce a negative number as the
result. Using those two numbers in another formula I get a positive number,
which is not what I want. What can I do to have the result remain a negative
number?