View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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 %.