+ Reply to Thread
Results 1 to 3 of 3

% choices

  1. #1
    Registered User
    Join Date
    07-30-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    9

    % choices

    Hi guys,i'm hoping i've got a simple question that i'm just being thick about, kind of can't see the wood for the trees...

    I'm trying to create a worksheet that selects a level of payment per item dependant on what % of target has been achieved.

    e.g. - if the % of target achieved is up to 80% - remuneration per unit =£75, if the % is between 81%-100% then its £100 per unit, if its 101% + then its £125 per unit.

    I can easily calculate what the percentages are,i just cant fathom out how to get the if,either or bit of the formula worked out.

    Please,any help will be appreciated...

    Dan

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: % choices

    If A1 contains the percentage, =LOOKUP(A1, {0,81,101}/100, {75,100,125})
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-30-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: % choices

    Perfect! thanks for you help,most appreciated.

    cheers

    Dan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1