View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 271
Default Need help with formula

Summary! refers to a worksheet in your workbook
$ is locking to J row as well as $18 is referring to Cell 18 and is divided
by 12
When $ in placed in front of a Row or Cell, if you drag the formula to other
cells, they will continue to reference row J Cell 18. Without the $, when
dragged - you would begin to see them change in sequential order depending on
the direction that you were dragging the formula to the next cell. IE -
pulled down the row would change to K - pulled right the cell would change to
19, etc.

So your Formula of =F51(times Row J Cell 18 divided by 12 in worksheet named
Summary)
--
Hope this helps!
Susan


"Ed B." wrote:

=F51*Summary!$J$18/12

This is a formula in a spreadsheet that I am using. It figures interest.
The interest rate has changed and I am not familiar with "Summary" or $ or J
or $ or where the 18 comes from. I know F51* and I know /12. Can someone
explain the other characters to me?