Calculated row number

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.
 
M

Mike Fenton

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
--------------------------------------------------------- -------------------






.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding redundant calculations 7
Macro to select and delete levels of a document 2
Repeating a row other than the 1st row as the header row in a table from next page 1
Display weeks from a Milestone 0
MATH COMPUTAION 6
Calculate the median value before a specified list 0
Autonumber field in Excel that behaves the same as Access 0
Help calculating scaled commissions please 5

Top