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