Stick the 17.5 in a cell then refer to that in your formulas.

Assumes 17.5 is in D1

Numbers are in Column A

In B1 enter =A1*$D$1

Double-click on the fill handle of B1 to copy down column B

The A1 will increment but $D$1 will remain the same.


Gord Dibben MS Excel MVP

On Fri, 25 Jul 2008 06:32:02 -0700, monalisa
wrote:

I know the formula for working out vat i.e =*17.5% is there a repeat formula
for cells to work out vat automatically , a am using excel.