Beginners question: VAT Column

[Dave Wallis]

Hello,

I know how to calculate VAT in a cell with the formula: =D14*0.175,
but I have created a VAT column. How do I apply the formula to the
entire column? Eg. so the calculation is applied to all cells in the
column: E14 to E200.

many thanks

 

[JE McGimpsey]

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(E14:E200 * 0.175)

 

[Bob Phillips]

If you mean the same calculation per row, just copy the formula down by
moving the cursor to the bottom right corner, and when it changes to a black
cross, click and drag down over the cells.

--

HTH

RP
(remove nothere from the email address if mailing direct)