Excell

Discussion in 'Microsoft Excel New Users' started by Guest, Feb 28, 2007.

  1. Guest

    Guest Guest

    Does anyone no how to set a formula to do this,
    there is different ranges like 0-499,500-799,800-999 and with each range
    there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
    falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
    Mike
     
    Guest, Feb 28, 2007
    #1
    1. Advertisements

  2. Guest

    Gord Dibben Guest

    =LOOKUP(B1,{0,500,800,1000},{0.01,0.02,0.03})*B1


    Gord Dibben MS Excel MVP

    On Wed, 28 Feb 2007 11:28:15 -0800, americasmattress8888
    <> wrote:

    >Does anyone no how to set a formula to do this,
    >there is different ranges like 0-499,500-799,800-999 and with each range
    >there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
    >falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
    >Mike
     
    Gord Dibben, Feb 28, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Gord

    excell 2002 format cell numbers

    Gord, Feb 23, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    519
    RagDyer
    Feb 23, 2004
  2. Guest

    Excell 2003

    Guest, Apr 3, 2004, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    270
    Guest
    Apr 3, 2004
  3. Octavio

    Excell attachement do no shows up

    Octavio, Apr 17, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    236
    Lady Layla
    Apr 19, 2004
  4. Guest

    Intrest calculations in eXCELL

    Guest, Jun 12, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    271
    Norman Harker
    Jun 13, 2004
  5. ABASSANETTI

    excell

    ABASSANETTI, Jul 9, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    230
    JE McGimpsey
    Jul 9, 2004
  6. Guest

    Excell devision formula

    Guest, Aug 8, 2004, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    285
    Peo Sjoblom
    Aug 8, 2004
  7. Guest

    Excell Worksheet formatting

    Guest, Aug 8, 2004, in forum: Microsoft Excel New Users
    Replies:
    7
    Views:
    286
    Bernard Liengme
    Oct 12, 2004
  8. Alek Luchnikov

    How to open MS Excell 2007 Sheet in MS Excell 2000???

    Alek Luchnikov, Mar 22, 2007, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    387
    gls858
    Mar 22, 2007
Loading...