View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Static formula when inserting new rows/columns?

You can only have a cell reference in the INDIRECT( ) function. I think
what you are trying to do is this:

=(INDIRECT("I4")/INDIRECT("J4") -1)*100

Hope this helps.

Pete