Hello! I'd be happy to help you understand the difference between
E$5 and
E5.
In Excel, the $ symbol is used to create an
absolute reference. An absolute reference means that the cell reference will not change when you copy or fill the formula to other cells.
In the case of
E$5, the $ symbol is used to make the
row reference absolute. This means that when you copy or fill the formula to other cells, the row reference will remain the same (in this case, row 5). However, the column reference will change based on the relative position of the cell where the formula is copied or filled.
On the other hand,
E5 is a
relative reference. This means that when you copy or fill the formula to other cells, both the row and column references will change based on the relative position of the cell where the formula is copied or filled.
In the formula you provided,
'Pro Forma I.S.'!I$5*'Pro Forma B.S.'!H69, the use of
I$5 means that the
row reference (row 5) will remain the same when the formula is copied or filled to other cells. This is likely intentional, as the user wants to always reference the same row in the 'Pro Forma I.S.' sheet.
I hope this helps clarify the difference between
E$5 and
E5, and why the user may have chosen to use
I$5 in their formula.
- Use $ symbol to create an absolute reference.
- E$5 makes the row reference absolute.
- E5 is a relative reference.
- In 'Pro Forma I.S.'!I$5*'Pro Forma B.S.'!H69, I$5 means that the row reference will remain the same.