Hi.

Setting out a spreadsheet with VAT calculations.

VAT rate is entered in a single cell as a reference and formulas refer to
this cell to make various calculations.

However when I use the copy function to copy the formula down the page to
work the various item prices out, the reference to the VAT cell is
incremented as well as the line reference.

How can I refer to the cell containing the VAT value so it remains as a
constant?

I want just one cell as VAT so that when the VAT rate is changed the whole
sheet can be updated simply by changing the value in that cell.

Roger R