I quickly tried this formula :
Which gave something looking like this :
Was this what you were looking for ?
Cost*Tax% field was just there to verify the math :winking_face: )
Total Cost is formatted as “Currency”. The
/100 To go around the bug with calculations with percentage.
Before, I used to do all this work in Excel, but over time, I realized that it is a waste of time and that there are very good alternatives. I already don’t even remember what formulas I use, and that’s why, unfortunately, I can’t help you with this. But instead, I recommend you make a pay stub. All the fees and taxes you pay on an online pay stub will also be calculated there. It is very simple. All you need is a pay stub generator, and within 2 minutes, your pay stub is ready. I recommend you to try it.