Originally posted by: ChAoTiCpInOy
Bottom right of the cell, drag it to wherever it is how far you want to go down.
Originally posted by: NeoV
even better - if you double-left click in the lower left corner of the cell with the formula, it will auto-copy it down to every row with corresponding data in row B