T
TC
I have a form, to calculate orders for my work. Everything is working until
I get to the subtotal and the hst. The subtotal, is adding it's self to the
total above, and therefore the HST is also doubled and then the total blance
is doubled. Here is a sample of some of my formulas to get the total of each
product is is =(Qty*Price*(1-Disc)) This one works, then to get the SubTotal
I used =SUM(ABOVE), to get the HSTis =(SubTotal+Freight)*.15, and the final
Total is =SubTotal+Freight+HST. If anyone can offer a soultion, that would
be great.
I get to the subtotal and the hst. The subtotal, is adding it's self to the
total above, and therefore the HST is also doubled and then the total blance
is doubled. Here is a sample of some of my formulas to get the total of each
product is is =(Qty*Price*(1-Disc)) This one works, then to get the SubTotal
I used =SUM(ABOVE), to get the HSTis =(SubTotal+Freight)*.15, and the final
Total is =SubTotal+Freight+HST. If anyone can offer a soultion, that would
be great.