Feb 21 2019 07:38 PM
Hello All,
I am trying to come up with a differential formula to let me know how I am doing on a month to month basis. So for example in Jan I earned 2,000 and then in Feb. I earned 2,600. In the differential cell (shown in picture below) I want to subtract C6-C5 and it tells me I'm up 600 for the year. so that's the easy part. what I'm trying to figure out is how do I make a formula to subtract C6-C5 then C7-C6 then C8-C7 once inputted and so on and so on. I attached a picture below to help. ANY help is much appreciated. thank you so much
Feb 21 2019 09:37 PM
Hi @spalmer
If you are looking to differentiate your current month income to the previous month, I would suggest adding another column next to monthly income and putting the formulas there. It makes more sense as you can track the whole year.
See image below for example:
I have also created for you an Excel file with the formula in action for you to test.
Hope that helps?
Cheers
Damien
Feb 22 2019 12:44 AM
Feb 22 2019 12:30 PM
Feb 22 2019 12:32 PM
Feb 22 2019 03:17 PM
So one more question for you guys if you don't mind... using the same table as above but this time instead of subtracting C6-C5 and C7-C6. How would I make a formula to subtract each month only from January. So C6-C5, then C7-C5, then C8-C5 and so on?
thank you for your time and help
Feb 22 2019 03:35 PM
You may use C$5 instead of C5 in first approach and
=INDEX(C5:C16,COUNT(C5:C16))-C5
in second one
Feb 24 2019 03:40 PM