View original (French)

VAT formula on MAC

fmm77 -  
Aliboron Martin Posted messages 3661 Registration date   Status Contributor Last intervention   -
Hello,

I'm having trouble programming a formula to calculate VAT at 20% for creating an invoice on NUMBERS (Mac)
if anyone can help me, that would be nice...
Just so you know, I'm a beginner on Apple, so a very simplified explanation would be appreciated.
Thank you

Configuration: Mac OS X (10.10.2) / Safari 8.0.3

1 answer

  1.
    Aliboron Martin Posted messages 3661 Registration date   Status Contributor Last intervention   992
     
    In Numbers, like any other tool, the VAT amount is obtained by multiplying the net amount by the applicable rate. For a net amount of €100 and a rate of 20%:
    100 x 0.20 = 20 => total including VAT = €120

    What exactly is the problem you are encountering with this?

    --
    Hello to you!
    Bernard
    3