How to give reference to a row number in excel formula?

Question

I need this formula: C(n) = B(n)*A5. (n is the row number)

Literally, multiply the current selected row number in column B with A5

I tried =ROW function for creating a reference but failed.

I tried with this formula: C(2) =MULTIPLY(B=ROW(),A5) thinking it will be parsed to C(2) =MULTIPLY(B2,A5)

Answer 1

You have two options to accomplish this:

1. INDEX() formula:

=INDEX(B:B,ROW())*A5

2. INDIRECT() formula:

=INDIRECT("B"&ROW())*A5

Where ROW() is the number of cell you're entering this formula into.