Use a formula to define row number

G

Guest

I would like to define the row number in a formula using a formula.

For example A(D2^2-1) would equal the value in cell A8 when D2 is equal to 3.

Thank you.
 

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

Excel Need Countifs Formula Help 0
Multiple IF statement not working 5
I am stumped. Help with Formula... 5
help with formula 1
Can a cell display blank under certain conditions? 2
Copy Formula Question 2
Formula via Define Name (not working) 3
Bad day for formulas 3

Top