Use of formula

Closed
Anonymous User - Mar 18, 2013 at 07:22 AM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Mar 18, 2013 at 01:52 PM
Hello,

l try to add up figures with vat but l coudn't get de total thanks.


1 reply

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
70
Mar 18, 2013 at 01:52 PM
Hi AYISATU,

If you mean "Value Added Tax" by the term "VAT", you can use the following method to calculate "VAT":

Enter sale price in cell A1: 100.00
Enter VAT / Tax in cell A2: 18.00%
Use the following function to calculate the net sale price: =A1/(100%+A2)
The result: 84.75
To calculate the VAT / Tax use the following function: =A1-A1/(100%+A2)
The result: 15.25

Do reply with results.
0