pricing

I am trying to use Vlookup from another open workbook that its name changes everything I get it. The name of book starts with "New Book Pricing" and date. Since the date is always changing I wouldn't know what it would be. Can I reference to this open book just by partial name which is "New Book...

I have a very complex project that I am working on that involves looking up historical pricing. Here are my challenges: Identical products are found in multiple catalogs and sometimes at a different price. Since pricing within a particular catalog may change occasionally, there are pricing...

Hi Everyone, This may be very simple but I really don't know how to do it. I need to create a pricing function with the following factors: Minimum Pricing: $2000 Maximum: $12000 Price per match: .35 I need a function that when a user plugs in a number of matches (F11), they will get a price...

Hi, I am working on an excel pricing model and need to make it dynamic, but don't have the best excel skills. I have two columns A and B. In column A there are 7 entries of different vendors and column B has their price next to it. I want to make a model for the prices, so if three are selected...

Hello world. I'd appreciate some help as I'm really not sure how to solve this complex problem in an efficient manner. I need to find a fast way to price potentially hundreds of items. I know that loops will be the slowest thing in the world because of the sheer number of things that EACH ITEM...

Folks, I have a spreadsheet with lots of parts and quantities that I'd like to discuss with two different parties (A and B), however I have two different pricing with both parties. I'd like to be able to chat with both of them at the same time to work toward the right quantities, but I'd...

Hey Guys! im new here but not so new in terms of using excel. But still when a friend of mine asked me for Help i didnt know where to start. task: we have a shop which offers different products. For example product A, product B etc. We have full knowledge of past data for those items - sales...

Hi Everyone, I have what has been a tricky problem for me. I have seen several posts on tiered pricing, which have been very helpful for calculating a basic tiered price system. But here's my situation: Items stored are on a tiered basis. If an item has been at a location for 0-15 days, its...

http://www.flickr.com/photos/79573271@N03/12418973234/ http://www.flickr.com/photos/79573271@N03/12418973114/ Hello. I am in need of writing a seemingly easy formula. I've attached two screen shots that should make sense of my request. Both spreadsheets are within the same Excel 2013 file...

I'm not even sure about how to word this question so I will try my best. I have the following situation. I am trying to make a pricelist for products which have multiple identifiers, but have it cover multiple customer locations. I'll try to explain. My table look like this: |Product ID1...

Hello The Scenario: the company I work for have four main customers who near the end of every month will e-mail a list of the stock they want, the maximum quantity they can accept and the price they can afford to pay per unit. Say for example we have 28 units of one item and the customers have...

Hi Guys, I am new to both this forum and excel and in need of some help. I have created a pricing table (Please see below and you are charged per unit in a tier structure. For example if I purchased 13,500 units, I would be charged 0.21 per unit for the first 10,000 units and for the other...

Function swapfx(startdate As Double, enddate as Double) As Double<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> <o:p> </o:p> Dim i As Double<o:p></o:p> Dim currmo As Double<o:p></o:p> Dim currmojump As Double<o:p></o:p> Dim price As...

We have 10 years worth of data in excel 2007 that shows our (varying) cost, sale price & margin with corresponding part #'s. Some of these part #'s have been entered more than once with a bogus alpha numeric prefix/suffix and still others have a dash mixed into it as well.<?xml:namespace prefix...

Hello All! I'm new to the board, Welcome Me! Welcome Me! :) OK, from what I've seen here so far I'm sure this formula is childs play! I could really use help creating it though. I'm working on this as we speak... Criteria: If current year suggested list price decreases from prior year...