I have a calculation sheet in excel in which I have to split 6% VAT and 21%. Each row is a different material, in each row is a total amount that will be added up to the summary table. in this summary table, there are 2 categories 6% en 21% because each material has its own VAT rate. I want to do this by putting a 1 (for 21%) or a 2 (for 6%) to the cell next the total amount. and then i want excel to know that when the number next to the total amount is 1 that the total amount needs to add up to the total amount 21% in the summary table
Solved by V. U. in 28 mins