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

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.

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

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.



On Jul 25, 9:32*am, 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.

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

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.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"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.

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

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

"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.

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

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.