Re: Excel - Multiple IF Criteria

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Product determines percentage of profit which are the numbers in the formulas
(e.g. .055)

Customer age also effects the profit as we charge customers less for certain
age groups.

Each product canhave a different rate for varying age ranges (e.g. 60-75 or
80-85.)

So, we need a formula that will take into consideration both of these
factors when calculating the projected revenue.

"JE McGimpsey" wrote:

While your example is clear, it's not clear to me how your factors
relate.


.

Relevant Pages

  • Re: Question for the home roasters
    ... He was not in the "egg" business ... My dad was, and is, the same way ... at the age of 93. ... met a man who went broke taking a little profit. ...
    (alt.coffee)
  • Listening Device for the Hard of Hearing
    ... I have an elderly neighbor who has difficulty with his hearing aids. ... It's fairly common at his age. ... I think he and others would profit greatly if he had a listening device he could hang around others, so that he could hear them speak. ...
    (sci.electronics.misc)
  • Re: Listening Device for the Hard of Hearing
    ... fairly common at his age. ... I think he and others would profit greatly if he ... had a listening device he could hang around others, ...
    (sci.electronics.misc)
  • Re: Tolkien Trust vs New Line
    ... Gene Ward Smith wrote: ... Is it still possible in this day and age to fall for the old ... to be in on the gross not the illusory Hollywood "profit" side of the pot. ... What's not in Columbia anymore.. ...
    (rec.arts.sf.written)
  • Re: IIf statement vs Select Case statement
    ... To compute the age from the date of birth you can add a simple function like ... You can call this in a query once you've added it to a module in your ... get a distinct count of the patients. ... which would allow you to get the age groups by joining ...
    (microsoft.public.access.queries)