Forum Discussion
Sum and subtraction
Thank you for clarifying. There are multiple ways to "automate" this issue to speed up your process. Are the documents you're using to count the number of products in a spreadsheet or are you manually counting?
If this is already in a spreadsheet, then a function can be used rather than a complex nested formula to allow for dynamic cell inputs.
"Are the documents you're using to count the number of products in a spreadsheet or are you manually counting?"
I dont need count the number of products. I just need to put the total of 6% products, and 23% products then, sum total of 6% and 23%. (i just need the value "€€€", i dont care if i have 1 or 23 products, for example).
example: Invoice nº 2535 - have total tax 6% of 300€ and total 23% tax of 500€; Sum tax = 800€
Thanks
Let me rephrase - is the source you're using for the input already in a spreadsheet?
- No. Is a paper!
Got it - looks like the nested IF function will be the best route.
Part 1: Formulas
Your formula(s) would be broken into three parts since you have three columns, which you can see in the example below (by each column):
*you need to adjust the formula for the first case on your end
Column 1 ' Subtracting total from other integer
=IF(AND(F1<>"",G1<>""),G1-F1,"")Column 2 ' Subtracting total from other integer
=IF(AND(G1<>"",E1<>""),G1-E1,"")Column 3 ' Adding both integers
=IF(AND(E1<>"",F1<>""),E1+F1,"")Part 2: Enable iterative calculation
To not get constant circular reference popups, you have to enable type of calculation in the Excel Settings.
Go to File > Options > Formulas > Enable iterative calculation