+ Reply to Thread
Results 1 to 3 of 3

Need an IF Function for a Weight Loss Challenge

  1. #1
    Forum Contributor
    Join Date
    11-18-2009
    Location
    Winnipeg
    MS-Off Ver
    Excel 2003
    Posts
    203

    Need an IF Function for a Weight Loss Challenge

    I need a formula that will input "10" into E4 in a cell IF:
    - D4 <= 0
    - D4 is among the bottom 2 of D4:D10

    Basically there are 7 people doing a weight loss challenge
    The 2 people with the lowest % of weight loss for the week owe $10
    AND everyone who gains or maintains pays $10 regardless of how many there are

    I hope I've given enough info. Let me know if you need clarification.

    Excel 2010 on this computer.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need an IF Function for a Weight Loss Challenge

    In E4

    =IF(OR(D4<=0,D4=MIN(D4:D10),D4=SMALL(D4:D10,2)),10,0)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    11-18-2009
    Location
    Winnipeg
    MS-Off Ver
    Excel 2003
    Posts
    203

    Re: Need an IF Function for a Weight Loss Challenge

    You are awesome thank you so much

+ 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