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:
- Calculating vat inclusive
- Vat calculation excel - Guide
- VBA code: calculating time difference - Excel Forum
- How to set up multiple taxes inclusive formula in Excel - Excel Forum
- Help with Formula calculating time on 24H shifts - Excel Forum
- Calculating normalized standard deviation in rolling window - Excel Forum
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
