How to create a table to qualify a qty discount in exel

Hi i'm creating a workbook to orginize stock, i'm not sure of how to create a 
table to give varying degress of discount according to the quatity bought ie: 
5 items or less =  no discount, 6 to 11 items =2% discount and so on, i have 
used an if statement so far but i'm not sure how it is meant to work in 
relation to the products and customers sheets, how does it all work together. 
Any help & guidence would be much appreciated.    
0
1image (1)
10/12/2005 3:28:03 AM
excel.newusers 15348 articles. 2 followers. Follow

2 Replies
547 Views

Similar Articles

[PageSpeed] 30

You can create yourself a lookup table, and use the vlookup formula. See:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"1image" <1image@discussions.microsoft.com> wrote in message 
news:EBB21404-A12F-4B9A-BD68-B949A735FF7F@microsoft.com...
> Hi i'm creating a workbook to orginize stock, i'm not sure of how to 
> create a
> table to give varying degress of discount according to the quatity bought 
> ie:
> 5 items or less =  no discount, 6 to 11 items =2% discount and so on, i 
> have
> used an if statement so far but i'm not sure how it is meant to work in
> relation to the products and customers sheets, how does it all work 
> together.
> Any help & guidence would be much appreciated. 


0
ng1 (1444)
10/12/2005 6:34:01 AM
See Chip Pearson's http://www.cpearson.com/excel/pricing.htm.

-- 
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <EBB21404-A12F-4B9A-BD68-B949A735FF7F@microsoft.com>, 
1image@discussions.microsoft.com says...
> Hi i'm creating a workbook to orginize stock, i'm not sure of how to create a 
> table to give varying degress of discount according to the quatity bought ie: 
> 5 items or less =  no discount, 6 to 11 items =2% discount and so on, i have 
> used an if statement so far but i'm not sure how it is meant to work in 
> relation to the products and customers sheets, how does it all work together. 
> Any help & guidence would be much appreciated.    
> 
0
10/12/2005 2:41:47 PM
Reply:

Similar Artilces:

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

Calculated Field in form to table
Can you take a calculated field from a form and pull it in to a table?? ...

PIVOT tables and publishing thrm on a webpage
Is there a way to publish a pivot table in a html page but still kee exactly the same funcitonality that you have on a Excel spread sheet either by converting it to a java applet or something else . Any hel would be much appreciate -- Message posted from http://www.ExcelForum.com ...

Pivot Table question #4
Hi I have spreadsheets that take data via a pivot table from an OLAP cube that is held on a terminal server. The spreadsheets hold figures entered by me and figures obtain from the pivot table. I want to enable the automatic update on the pivot table but the pivot table is sorted by a project number obtained from the OLAP cube. My problem is if a new project is added to the OLAP cube then it is automatically selected from the drop down list. I want to be able to turn this off so that it only selects the project I have previously chosed. For example if I have selected the filter nu...

table and form not calculated in synch
Help says to open a piviot table but I am having trouble making my columns add up to total for each indivudual ID. The totals are being calculated only in th e form view which does not up date the original table and does not transfer to a report. How can I get a feild to calculate specific feilds so that I can run these reports? ...

How to change background color of a window that has been created.
I need to change the background of a window that has been created, can you help? Hello Jerry, > I need to change the background of a window that has been created, can > you help? > Answer depends upon the type of window. Typically you can do this in OnEraseBkgnd. Certain controls respond to WM_CTLCOLOR and yet some other, like CButton, need to be owner drawn to change the color. If you have a generic CWnd, you can always specify the brush in the window class; so no special painting is needed. This is good when you know that the background will have one color all the time. -...

Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different tables that are created dynamically by a query. The data for these will change but I would like to simply pull the data from these tables to create a report. The tables have the following information: 1. Company Info (name, address) 2. Customer Info (address, name, etc) 3. Customer Order (products, price, other info) 4. Invoice Info (ID, GST #, etc) I realize I could have created a table with relationships but the data above is dynamic as there are 4 different companies and based upon user inp...

print folder in table style
Hello all, My CU wants to print a list of files in a folder. He use Outlook 2002. Click Other Shortcuts -> My computer -> choose a folder -> Click the print icon on toolbar -> choose Table Style -> print preview The header and footer can be printed properly. However the content is blank. I mean: there is no file in the list. I can print properly at my side. However at the CU side, there are 2000 users encounter the same problem. And there are four kinds of printer. All have this problem. Any suggestion? Thanks! ...

creating a recurring reminder email message
I want to create a reminder message that gets emailed to a distribution list on the same date every month. How can we do that? ...

GP Extender Tables Question (GP9)
I have created an Extender window with 3 Fields (let’s just say price 1, price 2, price 3). I can see where it got created in table EXT40100, field User_Defined_Prompts_1 etc and I can also see where the data is stored in EXT00103. What I don’t see is where the prompts from EXT40100 are in its own rows so that you can link them to EXT00103 for reporting purposes. I know I can hard code the flags to their proper values in Crystal or set up my own custom table to do it but I would have thought that Extender will have a table like that. Am I just not seeing it? -- Pieter The prompts ...

Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to include them after refreshing. Is there any way of setting the pivot table to include the entire database regardless of its continuously growing size? Right now, as I add a new row of data I must delete my old Pivot table and create a new one from scratch. Is this normal? You can use a dynamic range that grows/contracts with your data. Debra Dalgleish explains it all at: http://www.contextures.com/xlNames01.html#Dynamic David.c.h wrote: > > As I add new rows of data to my data base, my pivot table wil...

Problem creating full text index
I seem to be unable to create a full text index of either my public or private store. When I try to creat the index I get the error; The directory name is invalid. Facility: MSSearch.Admin.1 ID no: 8007010b Exchange system Manager This seems to be happening for both the public and private stores. The directory does exist. I have looked over the permissions and tried to compare to known working servers and I haven't moticed any obvious differences. Any ideas? Did you follow this article: http://support.microsoft.com/kb/822932/en-us Nue "Jonathan Huber" <JonathanHu...

How do I create a spread sheet for tracking batting statistics?
Trying to keep a running log of batting stats for the season. Can anyone help? http://www.baseball-almanac.com/bstatmen.shtml "Robert" wrote: > Trying to keep a running log of batting stats for the season. Can anyone help? ...

Install 3.0 Failed
I am in the process of installing 3.0 on a server. All of the inital checks are fine. I proceed to install and it fails with an error "Action Microsoft.Crm.Setup.Server.CreateSetupUserAction failed HRESULT 0x80040237" I searched the Knowledge Base and found KB 941498. I did what it said but got the following error for msxml2.dll - LoadLibrary("msxml2.dll") failed. The specified module could not be found. How do I go about getting XML 2 (the parser I'm guessing) when it hasn't be supported in years? Is there something else I can do? I am installing 3.0...

System Restore all off, still creating restore points on 2nd parti
Although we have System Restore turned off on all drives, restore points are still being created on the secondary partitions. The OS partiton is drive C, NTFS. The secondary partition is drive D, FAT32. The restore points are being created when applications (i.e. DirectX, WinDVD, etc.) are installed from the second partition (drive D). We must install these from a secondary partition. What are we missing? These restore points are filling up our drives. Also, I thought System Restore wouldn't work on FAT32 drives? Thanks, -- Bill Baker Bill, I use two drives b...

Create a new restore point
How does one create a new restore point in both Vista and Win7? When I go to Accessories-->System Tools-->Restore all I get is how to restore from a previous one. That's not what I want. I want to create a restore point. OldEd On 3/9/2010 5:14 PM, OldManEd wrote: > How does one create a new restore point in both Vista and Win7? When I > go to Accessories-->System Tools-->Restore all I get is how to restore > from a previous one. That's not what I want. I want to create a restore > point. > OldEd Click "Computer" in start menu th...

Turn on Automatic Formula Fill in Table
I turned off the 'automatically fill th column with this formula' option in Excell 2007 but I can't see how to turn it on again. Can anyone point me in teh right direction? TIA Excel 2007 Excel Options > Proofing > AutoCorrect Options > Autoformat As You Type > Fill formulas in tables to create calculated columns ...

Redefining a table range with a macro
Hello, I need help creating code to redefine a table within a macro. I used the macro recorder to creata a table with the same name but to point to another locations. ActiveWorkbook.Names("Table1").Delete ActiveWorkbook.Names.Add Name:="Table1", RefersToR1C1:= _ "='Sheet1'!R3C28:R12C37" How do I make this dynamic, so the starting point, #of rows and # of columns are defined by variables? Help is much appreciated. Regards, OMER On May 21, 4:57=A0pm, OMER <O...@discussions.microsoft.com> wrote: > Hello, > ...

restore .ost file created in different exchange profile
Does anybody know how to restore email and other data from an .ost file created by a different user in a different domain name, please? OST files are linked to the mailbox/profile for which they were created. If you've got an orphaned one, you can't open it - you will need to google OST2PST (an old utility that may still be floating around) and try to run it against the file (make a backup copy first). Or see www.exchangerecovery.com - I know it works, but it's $$$. hughie wrote: > Does anybody know how to restore email and other data from > an .ost file created by a di...

Checkbox column in a table
Hi Everyone, I am a newbie in MS Access. I want to write a query for altering a table such that the new column added should be of type checkbox (which can be done by the design by going to Lookup tab in the design form). So when I open up the table that particular column should be like all filled with checkboxes. (By Default it will be Textboxes). And also how to give a default value to the checkbox ? Please help me out... ! On Tue, 25 Sep 2007 12:52:20 -0700, Cormalado <Cormalado@discussions.microsoft.com> wrote: >Hi Everyone, > >I am a newbie in MS Access. I want to w...

Creating new P&ID master symbols
I would like to create a new master P&ID valve symbol and add it to the Valves and Fittings stencil. I want to duplicate the tags and properties of exisisting valves so that it functions like the other valves in the stencil (auto-numbers, same data fields, etc.). Is there a way to copy all the information (not just the shape properties) from one valve and apply it to the new one? Use the Shape Conversion command from the Process Engineering menu to do this. Here are the steps: 1) Drag an existing valve onto the page so that there is at least one valve in the document. 2) If your ...

Money 2005
I have used Money 2003 for 2 years now. I did not use ANY of the online features nor did I have a .NET Passport. I just purchased Money 2005. I took my existing .mny file and converted it for use in Money 2005. I enabled my checking account (from US Bank) to use online services. NOT ONLY did 2005 create a brand new duplicate account with my recent activity in it (see my other posting), BUT it also duplicated most of my existing budget categories too. For example, I had an existing category called "Day Care". Now I have two of them: "Day Care" and "Day Car...

Adding two fields to a table
I current have the following code which works perfectly now: [CODE]CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me. List12 & """)", dbFailOnError[/CODE] I would however like to add another field's information named (Lnd_Desc) as well in the same row of table (Input). What should my syntax look like for that one. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1 INSERT INTO [Input] ([Loc_Desc], [Other Column]) VALUES (""" & Me.List12 & ...

How do I create a 4-d chart?
I am trying to create a chart with 4 dimensions. In effect, I need a 3-D column chart where the vertical bars are "stacked" colmns. How can I do this? Evanr Have you heard about Tufte's "small multiples" or Cleveland's "trellis" displays? These approaches create a series of small plots instead of trying to put everything into a single overly complex chart. I would stay away form 3D charts in Excel. Trellis is a trademarked by Insightful software. I use the term "panel charts" to reflect trellis and small multiple charts in Excel. I have...

stop creating email link when @ sign is present
I want to stop the autoformatting when the @ sign is used in a field. How can I stop excel from automatically creating an email link when the @ sign is in a cell? Gregg, This feature can be turned OFF under Tools, AutoCorrect, the second tab, AutoFormat as You Type, unclick the first option Internet and Network Paths with Hyperlinks http://HelpExcel.com "gregg" wrote: > I want to stop the autoformatting when the @ sign is used in a field. How can > I stop excel from automatically creating an email link when the @ sign is in > a cell? gregg You don't say whic...