View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default i have expression - E$5 what is the difference from E5?

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" wrote:

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 $ :(