Re: Looking for a formula

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Thu, 4 Sep 2008 13:40:02 -0700, WCO <WCO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I need to see if it is possible to create a formula that will look for 2
variants to pull a range of 21 prices. For example if square foot is between
24-39 and qty=1 then it would pull a price of 10.00. This formula would
include 7 different square footage possibilities, 3 different quantity
options, for a total of 21 different price possibilities.

I wasnt sure if i could put the info on another tab and have the formula
pull from there or if it was easier to create a straight formula for it. Any
ideas are greatly appreciated.

If you can mathematically describe the relationship between quantity, size and
price, you could certainly use a formula.

Or you could just set up a table and use a combination of INDEX/MATCH to do the
lookup.

You need to provide more information.
--ron
.

Relevant Pages

  • Re: Electrical supply sanity check...
    ... A good string of nylon will pull in a rope to pull in what not. ... It's on the cusp of 400 or 500 MCM copper, and I'm probably just going 500 to be sure. ... They can, but they won't, or they price it so high that I won't, comes to the same thing in the end). ...
    (rec.crafts.metalworking)
  • Re: DLookup based on combo box on parent form
    ... itemunit ... The table "tblOrderDetails" is used for the subform. ... The problem I have is picking the right price. ... price on the subform to pull "location1pricing" from tblItems. ...
    (comp.databases.ms-access)
  • Re: Just looking
    ... Is the price right? ... I just want to keep my options open and pull the ... trigger at the right time. ... This is just a practice run. ...
    (rec.motorcycles)
  • Re: Price on a specific date change
    ... "SHIPP" wrote in message ... >I have finally gotten the query to pull the correct pricing date. ... instead of pulling the DateTimeField I want to pull the price. ...
    (microsoft.public.access.queries)
  • Re: Help please with a lookup problem
    ... My form sheet "DATA Sheet" has the same three columns. ... list of matching types but it also needs to pull in the price as well. ...
    (microsoft.public.excel.worksheet.functions)