Forum Discussion
Sum and subtraction
adversi and the rest people....
So, let me try explain again...
This is my Spreadsheet
columns:
N. Dev - is to identify the document (In this document (invoices and others) I have products with 6% tax, 23% tax and the total sum of the two tax.
I have to separate the products by tax)
6% - is tax produt (it's not important to what I want right now)
23% - is tax produt (it's not important to what I want right now)
Total = 6% + 23%
---------------//--------------
I have to enter the values of 6% and 23%, then the sum appears in column "F"
Image i put : C17+E17 =F17; 5+6=11€;
but sometimes it would be easier for me if I put the value 6% and the total and "excel" calculate the value 23%,; example F17 - C17 = E17; 11€ - 5€= 6€
or put the value of 23% and the total and calculate the value of 6% : example F17 - E17 = C17; 11€ - 6€ = 5€
regardless where i places the values, he can calculate the the third value.
Thanks!
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!