Auto calculating a VAT rate

S

Steve

Hello

I appreciate this is probably one of the easiest questions the ng has seen
this week (it is only Monday) but what is the formula for auto calculating
VAT rate of 17.5 %.

Ideally I would like to type a price in column A and a new figure including
VAT appears in column B automaticly.......

I have tried to work it out but is now officially doing my head in ;-))))

Many Thanks in advance

Steve
 
A

Arvi Laanemets

Hi

There is 2 different algorithms, depending VAT calculation rules.

1. VAT is calculated from endsum (like by us here in Estonia). When you have
in column A the prices without VAT, and in column prices with VAT included,
then
with A1 given, B1 will be:
=A1/(1-0.175)
with B1 given, A1 will be:
=B1*(1-0.175)

2. VAT is calculated from sum without VAT. When you have in column A the
prices without VAT, and in column prices with VAT included, then
with A1 given, B1 will be:
=A1*(1+0.175)
with B1 given, A1 will be:
=B1/(1+0.175)
 
S

Steve

Thankyou to you all, Is there a site that will show how to 'add' basic
formulas to my sheets.

TIA

Steve
 
S

Steve

Can I ask a follow on question to this post. I have two columns of numbers
now. Column A Price (ex VAT) Column B (inc VAT).......how can I get a 3rd
column that auto adds 50% onto the VAT figure.

I usually work to 50% mark up and it would be great if I could find a way
without using pen and paper.

TIA again ;-)

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New VAT Rate 3
Calculating VAT at different rates 6
IF statements help 1
Calculating rates using sumproduct 0
Formulaes 1
Caculations in Tables - Programming Methods 1
Programming Methods : Caculations In A Table 2
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! 0

Top