title: How to give reference to a row number in excel formula?
body: <p>I need this formula: C(n) = B(n)*A5. (n is the row number)</p>
  
  <p>Literally, multiply the current selected row number in column B with A5</p>
  
  <p>I tried =ROW function for creating a reference but failed. </p>
  
  <p>I tried with this formula: <code>C(2) =MULTIPLY(B=ROW(),A5)</code> thinking it will be parsed to  <code>C(2) =MULTIPLY(B2,A5)</code></p>