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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top