+ Reply to Thread
Results 1 to 6 of 6

Help!!!!im So Confused

  1. #1
    Registered User
    Join Date
    08-18-2005
    Posts
    1

    Question Help!!!!im So Confused

    im trying to set up a formula to give me a number based on the criteria of a cell. My goal is setting up a work sheet for a bonus plan. Bonus are only payed at a higher percentage after a certain amount.

    Example.

    if bill gates sales are 1 billion dollars or more, then his bonus is 15%... or ... if bill gates sales are 1 billion dollars or less, his bonus will be 10%... ect ect...

    any good Office Heads out there that can give this frustrated hardware engineer advice???? I can build them, trouble shoot them,, and repair them,, but when it comes to computer software and excell formulas,,, it might as well be an Apple... lol
    thanks for any help.
    Jim

  2. #2
    Registered User
    Join Date
    08-18-2005
    Posts
    1

    Re: confused...

    Jim,

    Did you figure this out, or are you still working on it?

    Kevin

  3. #3

    Re: Help!!!!im So Confused

    use a database for complex math like this

    excel is a disease


  4. #4
    Biff
    Guest

    Re: Help!!!!im So Confused

    complex math?

    LOL

    Biff

    <[email protected]> wrote in message
    news:[email protected]...
    > use a database for complex math like this
    >
    > excel is a disease
    >




  5. #5
    Biff
    Guest

    Re: Help!!!!im So Confused

    Hi!

    You have a conflict in logic here!

    If Bill Gates sales are $1 billion his bonus could be either/or by your
    description!

    The best solution to this depends on how many conditions there are. Just
    using the 2 you posted:

    Let's make the levels logic friendly:

    1 billion or greater = 15%
    Less than 1 billion = 10%

    A1 = sales

    Formula to calculate bonus:

    =IF(A1>=1000^3,A1*0.15,A1*0.1)

    Biff

    "james1bo" <[email protected]> wrote in
    message news:[email protected]...
    >
    > im trying to set up a formula to give me a number based on the criteria
    > of a cell. My goal is setting up a work sheet for a bonus plan. Bonus
    > are only payed at a higher percentage after a certain amount.
    >
    > Example.
    >
    > if bill gates sales are 1 billion dollars or more, then his bonus is
    > 15%... or ... if bill gates sales are 1 billion dollars or less, his
    > bonus will be 10%... ect ect...
    >
    > any good Office Heads out there that can give this frustrated hardware
    > engineer advice???? I can build them, trouble shoot them,, and repair
    > them,, but when it comes to computer software and excell formulas,,, it
    > might as well be an Apple... lol
    > thanks for any help.
    > Jim
    >
    >
    > --
    > james1bo
    > ------------------------------------------------------------------------
    > james1bo's Profile:
    > http://www.excelforum.com/member.php...o&userid=26437
    > View this thread: http://www.excelforum.com/showthread...hreadid=397064
    >




  6. #6
    Arvi Laanemets
    Guest

    Re: Help!!!!im So Confused

    Hi


    "Biff" <[email protected]> wrote in message
    news:[email protected]...
    > Hi!
    >
    > You have a conflict in logic here!
    >
    > If Bill Gates sales are $1 billion his bonus could be either/or by your
    > description!
    >
    > The best solution to this depends on how many conditions there are. Just
    > using the 2 you posted:
    >
    > Let's make the levels logic friendly:
    >
    > 1 billion or greater = 15%
    > Less than 1 billion = 10%
    >
    > A1 = sales
    >
    > Formula to calculate bonus:
    >
    > =IF(A1>=1000^3,A1*0.15,A1*0.1)


    Or
    =A1*(0.1+(A1>=1000000)*0.05)

    For
    less than 1000 =0%
    less than 1000000 =10%
    1000000 or greater =15%
    =A1*((A1>=1000)*0.1+(A1>=1000000)*0.05)

    For
    less than 1000 =0%
    less than 10000 =2%
    less than 100000 =5%
    less than 1000000 =10%
    1000000 or greater =15%
    =A1*((A1>=1000)*0.02+(A1>=10000)*0.03+(A1>=1000)*0.05+(A1>=1000000)*0.05)

    etc.


    --
    Arvi Laanemets
    ( My real mail address: arvil<at>tarkon.ee )



+ 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