Calculate % (7.75) in a cell for a different cell

[Guest]

I am making an invoice and I want to calculate the tax (7.75) for the
products sold, but I do not want the freight or deposits included in the
calculations of tax %.

 

[Guest]

Calculate the tax % on the net less freight and deposits then.

Example:

Item 1 = $100
Item 2 = $200
Freight & deposit = $50
Subtotal = $350
Tax @ 7.75% = ($350 - 50) * .0775 = $23.25
Total = $373.25

Dave

 

[Guest]

Tax is

=A1*0.775 where A1 contains taxable amount.

As you don't state what data is in what columns I cannot be more precise.

Are freight & deposits separate values i.e. separate cells?

 

[Guest]

Error ..

=A1*0.0775

or

=A1*7.75%