Photo by corina ardeleanu on Unsplash | How to Coda with VAT — Part II

How to Coda with VAT — Part II

Applying reductions

An important finding in our first blog on VAT was about two almost identical formulas. One to turn a base price into a price with VAT and one turning a price including VAT into a base price. See below.

Two related functions

Adding VAT requires the Product() logic, while for distracting VAT we apply its counterpart: Quotient().

In this blog we focus on how to give a reduction on a set of products as a fixed amount or as a percentage.

Percentage Or Fixed Amount

In the end a percentage is only step extra in the calculation. You take the percentage and multiply it by the price to have the amount. Once you have the amount you apply the described rules. This cannot be the difficulty. Indeed the trick is to know when to apply which version. Below what we use to get started.

Starting Point

First we have an If statement that shows which rule applies when the check box is (un) checked. In the above the reduction is written as percentage.

The Check Box linked to an If statement to show the right message

We have the Text Box where we can add information and we create an additional column to capture the reduction. We use a Regex Replace to remove information that would block the calculation like 100 Euro or 20% or 20 perc.

calculate the reduction

Our last step is to get a new base price. We have done that before. Below you see (again) how it goes.

This step is the preparation for our next challenge: imagine you want to decide if you give the reduction to the price VAT inclusive or VAT exclusive. This will be discussed in part III.

Conclusion

I hope you enjoyed this article. If you have questions feel free to reach out. Though this article is for free, my work (including advice) won’t be, but there is always room for a chat to see what can be done. Besides you find my (for free) contributions to the Coda Community and on Twitter

My name is Christiaan Huizer and I am the owner of Huizer Automation. A company specialized in serving SME in harvesting data and keeping it aligned. I am a Coda Consultant & Expert and rely mainly on Coda, Mailjet, Zapier & Paperform to get the job done.

Huizer Automation — Coda Expert and Coda Consultant on “How to Coda with VAT — Part II”

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Christiaan Huizer

Christiaan Huizer

I use Coda mainly for planning & calculations of all sorts. Follow me to learn how to Coda with numbers. I blog at least once per week.