i have expression - E$5 what is the difference from E5?

[Dmitrii]

Hello.

Please tell me what is the difference for example E$5 from E5?

In the document i need to understand there is a line - 'Pro Forma
I.S.'!I$5*'Pro Forma B.S.'!H69

i understand that we I5 from Pro Forma I.S. * H69 from Pro Forma B.S.

but i still cant undertstand why user who made this model used I$5?
I used this option in my test exell document and didnot saw the difference.
Please tell me it.
In help there are no coments about $

 

[John]

the $ in a cell reference makes either the row, column or the complete cell
absolute. So E$5 makes the row absolute so if you use the fill handle a fill
the formula across rows the column will change but the row number is fixed at
5
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Mike]

Hi,

A $ sign makes the address absolute. For example =$A$5 as a formula would
not change no matter whwre it was dragged or copied to compared to =A5 which
if dragged down would become =A6 etc.

In your specific case the row (5) is absolute and the column (I) isn't so if
it was dragged left or right the 'i' would alter but if dragged up and down
the '5' would remain the same.

Mike

 

[Dmitrii]

Thank you Mike.
You gave a greate answer. It help's me very much.