How do i calculate VAT inclusive
Closed
moonga
-
13 Apr 2017 à 08:36
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 13 Apr 2017 à 10:21
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 13 Apr 2017 à 10:21
Related:
- How to calculate vat inclusive
- Vat calculator excel - Guide
- Vba calculate - Guide
- Calculate mtu - Guide
- How to calculate position in excel ✓ - Excel Forum
- Calculate years - Office Software Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
13 Apr 2017 à 10:21
13 Apr 2017 à 10:21
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
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
