How do i calculate VAT inclusive
Closed
moonga
-
Apr 13, 2017 at 08:36 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 13, 2017 at 10:21 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 13, 2017 at 10:21 AM
Related:
- How do i calculate VAT inclusive
- Vat inclusive formula - Guide
- How to calculate 90 days from date in excel - Guide
- How to calculate in spreadsheet - Guide
- How to calculate bece grades - Excel Forum
- How to calculate number of words in ms word - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 13, 2017 at 10:21 AM
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
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
