View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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 %.