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

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

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

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
--
Brevity is the soul of wit.


"Debe" wrote:

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

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

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?

"Debe" wrote:

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

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

Error ..

=A1*0.0775

or

=A1*7.75%

"Debe" wrote:

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