Is there a formula to express the net change in the value of a cell on daily basis?

%3CLINGO-SUB%20id%3D%22lingo-sub-1577394%22%20slang%3D%22en-US%22%3EIs%20there%20a%20formula%20to%20express%20the%20net%20change%20in%20the%20value%20of%20a%20cell%20on%20daily%20basis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1577394%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20cell%20whose%20values%20changes%20on%20daily%20basis%20because%20of%20the%20changes%20different%20departments%20make%20in%20the%20source%20sheet.%20I%20want%20to%20know%20how%20much%20the%20cell%20value%20has%20increased%20or%20decreased%20on%20a%20daily%20basis%20-%20the%20net%20change%20in%20the%20value%20of%20that%20cell.%20In%20other%20words%2C%20I%20want%20to%20subtract%20yesterday's%20value%20of%20that%20cell%20from%20its%20today's%20(latest)%20value%20and%20return%20the%20difference%20in%20another%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20with%20the%20formula%20to%20do%20this.%20Thanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1577394%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1577575%22%20slang%3D%22de-DE%22%3ESubject%3A%20Is%20there%20a%20formula%20to%20express%20the%20net%20change%20in%20the%20value%20of%20a%20cell%20on%20daily%20basis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1577575%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751212%22%20target%3D%22_blank%22%3E%40sohailzamani%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMaybe%20through%20this%20information%20first%20determine%20the%20change%20and%20then%20the%20desired%20mean%20value%20with%20a%20formula%20...%20is%20just%20one%20thought.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-501678607%22%20id%3D%22toc-hId-501678607%22%20id%3D%22toc-hId-501678607%22%20id%3D%22toc-hId-501678607%22%3E%3CFONT%20size%3D%223%22%3EHow%20to%20run%20a%20macro%20when%20certain%20cells%20change%20in%20Excel%3C%2FFONT%3E%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Foffice%2Ftroubleshoot%2Fexcel%2Frun-macro-cells-change%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Foffice%2Ftroubleshoot%2Fexcel%2Frun-macro-cells-change%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1609733%22%20slang%3D%22en-US%22%3EBetreff%3A%20Is%20there%20a%20formula%20to%20express%20the%20net%20change%20in%20the%20value%20of%20a%20cell%20on%20daily%20basis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1609733%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20thanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20try%20this%20solution%20and%20see%20if%20that%20works%20for%20me.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ESohail%20Zamani%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1609748%22%20slang%3D%22en-US%22%3EBetreff%3A%20Is%20there%20a%20formula%20to%20express%20the%20net%20change%20in%20the%20value%20of%20a%20cell%20on%20daily%20basis%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1609748%22%20slang%3D%22en-US%22%3EWill%20the%20same%20work%20in%20Google%20Sheets%20as%20well%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a cell whose values changes on daily basis because of the changes different departments make in the source sheet. I want to know how much the cell value has increased or decreased on a daily basis - the net change in the value of that cell. In other words, I want to subtract yesterday's value of that cell from its today's (latest) value and return the difference in another cell.

 

Please help me with the formula to do this. Thanks a lot.

3 Replies
Highlighted

@sohailzamani 

Maybe through this information first determine the change and then the desired mean value with a formula ... is just one thought.

How to run a macro when certain cells change in Excel

https://docs.microsoft.com/en-gb/office/troubleshoot/excel/run-macro-cells-change

 

I would be happy to know if I could help.

Nikolino
I know that I don't know (Socrates)

Highlighted

Great thanks @Nikolino 

 

I'll try this solution and see if that works for me.

 

Regards,

Sohail Zamani

Highlighted
Will the same work in Google Sheets as well?