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

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

=SUM(E14:E200 * 0.175)

In article ,
(Dave Wallis) wrote:

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.

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)


"JE McGimpsey" wrote in message
...
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(E14:E200 * 0.175)

In article ,
(Dave Wallis) wrote:

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.