Hello,
I’m trying to figure out a way to calculate my “Price without Tax”.
I wrote something like this but it’s not working.
IF({VAT}=20, {Price with tax}/1.2), IF({VAT}=5.5, {Price with tax}/1.055))
VAT is a Percent
As you can probably see i’m a tru...
Hello,
I’m trying to import accounting from a CSV file in Airtable.
In the CSV file the number is formatted like this :
3240,50 (European format - Three thousand two hundred forty Euro and fifty Cents)
When i import in Airtable it become :
324,050.00...
augmented:
IF(AND({VAT},{Price with tax}), {Price with tax}/(1+{VAT}),0)
Thanks @augmented for your help.
My concern is that i can have 2 different VAT values (20% and 5,5%)
I just want my “Price without Tax” to be calculated according to the ...
Merci @Rodolphe_Cantillon,
Est-il possible que tu me détailles un peu plus la démarche à suivre précisément.
Je suis très intéressé mais assez novice dans ce genre de manipulation et formules.
Merci d’avance.
Hi @Nathalie_Collins,
Thanks for you answer.
I tought about that too, as you said it’s not ideal but why not.
But it appears not as simple as that.
I tried and it doesn’t work.
From what i get it’s because you can’t do with “numbers” what you can do ...
Hello @W_Vann_Hall,
I found Number and Currency ‘Pretty-Print’ Routines but it’s kind of too advanced for me and i’m not sure what to do with that.
Can you help me or at least point me to someone who can ?
Thanks
