Use of formula

[Closed]
Report
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,

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


1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
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.