What are you getting now, Sharon?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Sharon Durow" <Sharon wrote in message
...
I need to work out a formula that calculates the difference between to
weights. The problem is that weight gain needs to be shown as a positive
and
weight loss as a negative, I am having problems finding a way to
automatically calculate the correct answer. I can format in colour but
really
need the figures showing pos and neg.