A total Formula (Help)

T

Tia

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
 
F

Fred Smith

How is the deduction calculated? A percentage of cost*quantity? If so, try:

=d13*e13*(1-f13)

Regards,
Fred
 
D

David Biddulph

In G13 use =D13*E13*(1-F13)
[... assuming that you've put a percentage value like 20% in F13; if
you've just put 20, then change the formula to =D13*E13*(1-F13/100) ]

And in all honesty, this isn't really an Excel question. Before you try to
use Excel, it is always wise to know what calculation you want to carry out.
It is difficult for Excel or any other tool to provide the answer if you
don't know the question.
 
Top