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
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 18, 2013 at 01:52 PM
Related:
- Use of formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 18, 2013 at 01:52 PM
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.
