View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia[_3_] Tia[_3_] is offline
external usenet poster
 
Posts: 79
Default A total Formula (Help)

Hi
I am trying To do a daily calculation for a shop but i cant find a
formula that gives the total amount
minus a deduction %
My table is the following
B13= Item
D13=Cost
E13= Quantity
F13= Deduction %
G13= Total

I wana have a formula that gives me
Total =Cost*Quantity-deduction amount

I want a formula that allows me to have the total of the amount payed
for each item


Best Regards