show difference between weights with correct pos and neg values

S

Sharon Durow

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.
 
R

Roger Govier

Hi Sharon

=new_weight-old_weight.

With old_weight in A1, and new_weight in A2
=A2-A1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top