Difference formula advice.

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
4,560
Office Version
  1. 2007
Platform
  1. Windows
Hi,

Can you advise please.
I have a record a dog weights and have them in a simple spread sheet.
What i would like to do as opposed to making just entries of each weight each time is to be able to apply a formula so i can see the + or - difference in weight on the previous entry

Example.
May 2014 29KG
June 2014 30.5Kg + 1.5Kg
August 2014 28.5Kg -2Kg
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,426
Office Version
  1. 2019
Advice: Remove kg from all cells so only numbers remain.
Assuming the date is in column A and weight is in B

format C2 as Custom with type of
+0.00;-0.00

in C2
=B2-A2
 
Upvote 0

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
4,560
Office Version
  1. 2007
Platform
  1. Windows
I do not see +0.00;-0.00 in the type drop down options ?
 
Upvote 0

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
4,560
Office Version
  1. 2007
Platform
  1. Windows
Yet again i learn something.
I thought you could onlt select from the drop down box, didnt know you could put the +0.00;-0.00 in place of where it read General.
Anyway got it working but need some more added to the formula,see below please.
F6 = SEPT 2014
G6 = 33.1
H6 = +3.00 "as last weight entered was 30.1"

What i now see in H7 is -33.10 because its taking into account of the last entry G6 "33.1"
After that all cells read +0.00

I would like these cells in H to all read "nothing" until i actually enter my data in the cells as and when i weigh the dogs.

Thanks very much.
 
Upvote 0

Forum statistics

Threads
1,191,353
Messages
5,986,162
Members
440,007
Latest member
cjw29209

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top