Calculated row number

  • Thread starter Thread starter Mike Fenton
  • Start date Start date
M

Mike Fenton

Is there a way to write a formula or a function that will
allow me to calculate which row number Excel should look
to? i.e.: 32*A3+6 would calculate the row number L'xx'
for Excel to look at and reference.
Thanks in advance.
 
You are a life saver. Keep up the great work!!!!
-----Original Message-----
=INDIRECT("L"&(32*A3+6))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------- -------------------
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------- -------------------






.
 
Back
Top