How do i calculate VAT inclusive

[Closed]
Report
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
Hello,
how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18%


1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
moonga, Good morning.

Suppose:
A1 --> 849235

Try to use:
NET VALUE
C1 --> =A1/1.18
C1 --> 719690.68

VAT
B1 --> =A1-(A1/1.18)
B1 --> 129544.32

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão