Simple percentage formulas

[Guest]

I would like to have Excel work out the VAT purchase tax element at 17.5%, automatically, in the VAT column cell next door to my nett amount column on my Sales Invoice ledger. So if the job price was £100.00 I want the VAT cell reading £17.50. I've tried every combination of formula I can think of and consulted "Microsoft Excel help" under the Help menu

I'm sure it must be possible to do this. All suggestions gratefully accepted

Regard
Michae

 

[Jim]

=Price*0.175

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

I would like to have Excel work out the VAT purchase tax element at 17.5%,

automatically, in the VAT column cell next door to my nett amount column on
my Sales Invoice ledger. So if the job price was £100.00 I want the VAT cell
reading £17.50. I've tried every combination of formula I can think of and
consulted "Microsoft Excel help" under the Help menu.

 

[Bob Phillips]

Michael,

I create a named range (menu Insert>Name>Define...) with a name of VAT and a
RefersTo value of =17.5%. This way, we can use a formula such as

=A1*VAT

If VAT changes, it's simple to redefine the value and the formulae
automatically update.



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I would like to have Excel work out the VAT purchase tax element at 17.5%,

automatically, in the VAT column cell next door to my nett amount column on
my Sales Invoice ledger. So if the job price was £100.00 I want the VAT cell
reading £17.50. I've tried every combination of formula I can think of and
consulted "Microsoft Excel help" under the Help menu.

 

[Guest]

Hi Bo

Thanks for responding so promptly. I'm going to try your named range formula

Regard
Michae

----- Bob Phillips wrote: ----

Michael

I create a named range (menu Insert>Name>Define...) with a name of VAT and
RefersTo value of =17.5%. This way, we can use a formula such a

=A1*VA

If VAT changes, it's simple to redefine the value and the formula
automatically update



--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

I would like to have Excel work out the VAT purchase tax element at 17.5%

automatically, in the VAT column cell next door to my nett amount column o
my Sales Invoice ledger. So if the job price was £100.00 I want the VAT cel
reading £17.50. I've tried every combination of formula I can think of an
consulted "Microsoft Excel help" under the Help menu

 

[Guest]

Hi Ji

Many thanks for your quick response – I don't have to struggle with the old calculator any more now

Regard
Michael