Feb 02 2020 03:05 PM
Sorry, but I'm not a native English speaker and I better explain this as simple and graphic as I can:
My friend has a business and he wants to give his costumers a note he is writing in Excel, showing how much each item they have bought cost, and then the sum without 25% tax, then how much the 25% tax is, and at the end the sum incl tax.
Let's say the numbers are written in column C:
From C1 to C10 we have a list of the cost of each item,
C11 shows the sum of C1 to C10 (without 25% VAT)
C12 shows much much the 25% VAT is
C13 the total of the sum in C11 + the VAT in C12.
But I don't know what formel write in C12 to find or calculate the 25% of the sum in C11?
After trying so many things and googling for days without any success, I now hope so much anyone here can help me.
Thank you so much,
Pia
PS: I'm not kidding; the Danish VAT really is 25% !!
Feb 02 2020 04:10 PM
Feb 02 2020 04:18 PM