Negative numbers in resulting formula
 

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?

Negative numbers in resulting formula
 

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?

Negative numbers in resulting formula
 

Yep, just add "*-1" to the end of your formula

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