Friday, January 27, 2012

yogi_Calculate Total Amount For Taxable and Non-Taxable Items Sold

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user m-j-p said:
I am trying to calculate only particular cells in a range. For instance:
Column A | Column B
1 Yes |  $5
2 No  | $10
3 Yes | $20
4 No  | $15
5 No  | $20
I would like to perform the following calculation. If A1 = "Yes" then add 6% to B1 and apply that same rule for a range of cells to arrive at a total. So for instance the calculation in the scenario above would be: A1 * 1.06 * B1 + A3 * 1.06 * B3 = $26.50. I'm basically using this formula so I can quickly calculate all of the taxable sales for when I do my sales tax at the end of the month.
update:
Thanks again for the help!
One more question regarding this same formula. How would I properly write the formula to have another IF statement?
For instance: IF((E1;"Yes";F1)*1.06, IF(E1;"No",F1)*1) ? Basically going to have a subtotal and total column and the total column will add 6% to the subtotal if "Yes" and if "No" it will not add to the total.
-------------------------------
following is a solution to the problem