How do i calculate VAT inclusive

Closed
moonga - Apr 13, 2017 at 08:36 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Apr 13, 2017 at 10:21 AM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Apr 13, 2017 at 10:21 AM
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
0