Use of formula
[Closed]
Report
Anonymous User
-
Zohaib R
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Use of formula
- Spreadsheet formula - Articles
- Excel @ in formula ✓ - Forum - Excel
- 1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
- How to copy data from one sheet to another in excel using formula - How-To - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
1 reply
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
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.
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.
