Calculate tax based on Yes or no answer

Hi @Kayla_Gorst,

Please show us the setup of your table to be able to help you. And yes, you can base IF formula on the Yes No answer in the previous field.

BR,
Mo

So I have the column (Tax included) I would like to be able to check this box Y/N. If checked Yes I would love it to calculate taxes in my tax column. - It is not letting me add an image for some reason…

Does something like this work?

{Pre-tax Amount} *
IF(
   {Tax included},
   1.085,
   1
)

It assumes the amount being taxed is in a field called {Pre-tax Amount} (change to your field name), and if the checkbox field {Tax included} is checked, it will multiply that amount by 1.085, simulating an 8.5% tax. If the checkbox field {Tax included} is not checked, it will multiply that amount by 1, simulating no tax being added.