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

Similar Threads

Percentage of Weight Loss/Gain 4
The right formula is? 2
Scroll does not show preview 0
Separte columns for neg/pos values 2
URGENT - Need to match debits and credits 1
How to calculate difference between two date & time along with working hours and days 2
calculate shipping costs in excel 2007 3
Difference between two date/time values 6

Top