title: Multiply two columns by a scalar
body: <p>I'd like to multiply the value of a given cell by a scalar and output the result to an adjacent cell. For example, if I had:</p>
  
  <pre><code>     B    C
  1    25   ?
  2    20   ?
  3    21   ?
  4    23   ?
  </code></pre>
  
  <p>I want the <code>?</code> values in each C column to be <code>20 * (B in same row)</code>. i.e. (<code>C1 = B1*20, C2=B2*20, C3=B3*20, ...</code>). I know I could do this individually for each row, but I'm hoping to do it for the entire column at once.</p>
  
  <p>I'm using Excel 2008 for Mac if that is relevant.</p>