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

D

Debe

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 %.
 
D

Dave F

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
 
T

Toppers

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?
 
Top