•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Misunderstanding cell referencing. The copied formulas are acting like I have put an absolute cell reference when it should just be the Column locked not the row as well.
Our take
Are you puzzled by cell referencing in your spreadsheet? It’s common to misinterpret how absolute and relative references function, especially when copying formulas across columns. In your case, it seems like the formula in cell B32 is behaving like an absolute reference, locking both the column and the row when you intended to lock only the column. Understanding the difference between these references is crucial for achieving the correct calculations in cells B34, C34, and D34.
Hello all, I am trying to understand why my formula is acting like I have an absolute cell reference in cell B32 when I set it to keep only the same column(column B). I wanted to copy this simple formula across columns, but the copied formulas stay column B and row 18. I thought if I put $ in front of the column only the row would change with the formula, but it did not. What am I not understanding about cell references here. For reference, the values in B32, C32, and D32 are what my formulas in cells B34, C34, and D34 should amount to. Any help would be appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience