View Single Post
  #1   Report Post  
Anne Troy
 
Posts: n/a
Default

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