Thread
:
Static formula when inserting new rows/columns?
View Single Post
#
5
Posted to microsoft.public.excel.misc
Pete_UK
Posts: n/a
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
Reply With Quote