Posted to microsoft.public.excel.worksheet.functions

Tia[_3_]

external usenet poster

Posts: 79

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
what formula to get total from two different columns	Mikeymike	Excel Worksheet Functions	2	October 18th 06 06:58 PM
why does a formula not total right?	Kickstart	New Users to Excel	2	April 11th 06 01:59 PM
Old Lotus Sub Total & Grand Total formula	Kylie	Excel Discussion (Misc queries)	2	April 9th 06 12:24 PM
XL formula - total of row = total of column	topaz	Excel Worksheet Functions	2	March 17th 05 10:04 PM
Total formula	Rebecca	Excel Worksheet Functions	1	March 2nd 05 03:19 PM

All times are GMT +1. The time now is 09:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us