Positives and Negatives
 

I need a formula what will tun a positive number in to a negiive.


=SUM($H$5:H6)+(B4)

B4 is a negitive number and so my anser apears negitive, but I would like it
to apear possitive by adding to the formula not my chainfg any of my numbers
in to a positive. Can this be done ??

If you want positive numbers, then just =ABS(SUM($H$5:H6)+(B4))

************
Anne Troy
www.OfficeArticles.com

"Niagera College Student"
wrote in message ...
I need a formula what will tun a positive number in to a negiive.


=SUM($H$5:H6)+(B4)

B4 is a negitive number and so my anser apears negitive, but I would like
it
to apear possitive by adding to the formula not my chainfg any of my
numbers
in to a positive. Can this be done ??

Thank you so vary Much, I have been racking my brain for an hour and the
answer was so simple. Just the right remedy.


"Anne Troy" wrote:

If you want positive numbers, then just =ABS(SUM($H$5:H6)+(B4))

************
Anne Troy
www.OfficeArticles.com

"Niagera College Student"
wrote in message ...
I need a formula what will tun a positive number in to a negiive.


=SUM($H$5:H6)+(B4)

B4 is a negitive number and so my anser apears negitive, but I would like
it
to apear possitive by adding to the formula not my chainfg any of my
numbers
in to a positive. Can this be done ??