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

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