Use of formula
Closed
Anonymous User
-
Mar 18, 2013 at 07:22 AM
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
- Little alchemy formulas - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
- Logitech formula vibration feedback wheel driver windows 10 - Download
1 reply
Zohaib R
Mar 18, 2013 at 01:52 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
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.
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.