show difference between weights with correct pos and neg values

G

Guest

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

Formula nesting with IF statements 2
The right formula is? 2
Separte columns for neg/pos values 2
calculate shipping costs in excel 2007 2
subtract a positive from a negative 7
Excel: want neg numbers to show red/pos green via if-then formula 3
Formula for neg and pos values 4
Any formula to return the most frequent bin range? 15

Top