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.
Bookmarks