is there a formula for working out vat without repeating *17.5%

[monalisa]

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.

 

[Tim879]

I don't know of a formula but you can try this to see if it makes
calculating the VAT faster


type 17.5% in a blank, unused cell. click copy

highlight the area where you want to calculate the VAT (for instance
if you want to multiply all of column B by 17.5%, hightligth all of
column B)
Go to Edit->PAste Special -> select multiply and formulas (so you
don't change the formatting unintentionally) and hit ok

Everything that you highlighted will not by multiplied by 17.5%.

Alternatively.... you could use the product function.

 

[M Kan]

You'd just use the formula =Cell_ref * .175 and then copy it down your list
of values. Maybe I'm not understanding something right.

 

[Mike H]

Possibly even more intuative is

Select a cell then
Insert|Name|Define and call it VAT
Enter 17.5% in the named cell

You can then use formula like

=C1*Vat

To work out the VAT on C1

Mike

 

[Gord Dibben]

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