Because the tax rate does not change, why can't you just make Column B automatically calculate 5.3% of each entry in column A? How would one do that? And then in the Total column, have it add A +B and display the Total?
I figured it out. To calculate the TAX RATE to other rows, enter this formula "A2*B$2" the dollar sign keeps it in place for some odd reason. I'm sure there's a proper explanation, but I tried to help.
Thanks so much for the help. I couldn't figure this out on my own :)
this is cool, just took some bits out of it to add to my own, thanks it was straight to the point.
Very Helpful. Sweet and to the point. Thank You VERY MUCH.
Because the tax rate does not change, why can't you just make Column B automatically calculate 5.3% of each entry in column A? How would one do that? And then in the Total column, have it add A +B and display the Total?
This is what I am looking for
I figured it out. To calculate the TAX RATE to other rows, enter this formula "A2*B$2" the dollar sign keeps it in place for some odd reason. I'm sure there's a proper explanation, but I tried to help.
It was very helpful thanks 👍
Wow