Forum Discussion

Dieter zur Loye

Copper Contributor

Nov 12, 2018

Excel formula

I have a formula in K75 (=K22+K31+K51+K69) I copied this formula into K72 and received a different result. How is that possible?

Formulas and Functions

Diamond Contributor

Nov 12, 2018

Hi Dieter,

Since it'll be another formula. Please check what is the difference between absolute and relative references here https://support.office.com/en-us/article/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9

Resources