Thread: Insertion of a cell address that constantly rises by a set number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Insertion of a cell address that constantly rises by a set number
On Aug 24, 8:50 pm, stew wrote:
I have a large spread sheet I am working on and I wish to increase a cell
address by 103 every time
ie
=L103,= L206,=L309 ETC

Is there a formula that will increase this address

thank you

Maybe...
=IF(INDIRECT("L"&103*ROWS($1:1))="","",INDIRECT("L "&103*ROWS($1:1)))

Ken Jhnson
Reply With QuoteReply With Quote