Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Greater Than, Less Than formula (Excel 2000)

    I am having trouble with a formula that needs to read the following way:

    If the actual total is greater than 85% (but less than 91%), then the percent payout will be 2%. If the actual total is greater than 90% (but less than 100%), the percent payout will be 4%. If the actual total equals 100%, the percent payout will be 6%.

    I'm having a difficult time because I can't seem to enter "greater than but less than" in the same statement. Looking at Row 7. Please see attached doc.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Greater Than, Less Than formula (Excel 2000)

    Try a formula like this:

    <code>=IF(B3<85%,0%,IF(B3<90%,2%,IF(B3<100%,4%,6%) ))</code>

    It is not quite clear whether to use < or <= since your description is contradictory (less than 91% and greater than 90% overlap)

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Greater Than, Less Than formula (Excel 2000)

    How about:

    =SUM(IF(B3=1,0.6,IF(B3>0.9,0.04,IF(B3>0.85,0.02,0) )))

    I am not sure what to do with 0.90 - 0.91 since you have some overlap so I ignored this.

    Steve

Posting Permissions

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