Tech Support Forum banner
Status
Not open for further replies.
1 - 2 of 2 Posts

· ID10T Circuit replacement
Joined
·
1,038 Posts
If you want the tax total above the "Grand" total.
total cell is the total all added up (ie d1, e3 whatever)

=(total cell * .08)

if you want a total including the tax
=(total cell * 1.08)

I hope this is what you needed.

for the "grand total"

=(above cell + the total cell)


a1 = 3.00
a2 = 4.00
.
.
.
a7(total cell) formula =sum(above)
a8(tax) formula =(a7*.08)
a9(grand total)formula =(a7+a8)
 

· ID10T Circuit replacement
Joined
·
1,038 Posts
After you draw a table and your columns and rows the are a-z across the top and 1-100 on the side. Don't use the lines and column indicator.

a b c
______________
1 |____|____|____|
2 |____|____|____|
3 |____|____|____|
4 |____|____|____|

etc....
Write the formula to be: in a3
=(a1+a2)*.08)
Formula for a4
=(a1+a2+a3)

I really don't know how you get the column names and numbers, I usually just use smaller tables. Anybody else jump in and help me with this?
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top