# 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.

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.

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.

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.

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

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.

--

--

## More from 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.

Love podcasts or audiobooks? Learn on the go with our new app.

## 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.