You can calculate 17.5% vat in Microsoft Excel by using this formula.
Number x7 /47
You multiply the number by 7 and divide by 47 to get the vat amount.
You can also calculate the new UK 15% vat rate in Microsoft Excel by using this formula.
Number x3/23
You multiply the number by 3 and divide by 23 to get the vat amount.
Thank you so much!
Gotta love simple solutions that work
Thank u so much! I gotten something dt has been given me problem.
How do you calculate 20% VAT then?