How do you properly input multiple formulas in one cell so that all formulas are executed and one one text value is shown in the cell?
I am choosing basketball players to be on my fantasy team. I am the 4th person to pick each round between 10 people. Once a basketball player is chosen by my friends, I want a new option to populate in my cell to help me decide who to choose next.
With the help from another thread, I was able to get =IF(COUNTIF($C$2:$C$4,"WESTBROOK"),"HARDEN","WESTBROOK") to work, but I want to be able to do this with many many players and many different scenarios.
Does anyone know the best/easier way to do this? If I have to punch in every formula for each player contingency that is fine with me, but I can not get the multiple formulas to work in that one cell.
Here is the example of what I am doing wrong...
I input this formula into C5:
=IF((COUNTIF($C$2:$C$4,"WESTBROOK"),"HARDEN","WESTBROOK"), IF(COUNTIF($C$2:$C$4,"HARDEN"),"CURRY","HARDEN"), IF(COUNTIF($C$2:$C$4,"CURRY"),"DURANT","CURRY"))
what I want is if WESTBROOK is chosen by the first three guys, then my next choice will be HARDEN. If HARDEN is also chosen by the first three guys then my next option is CURRY, and if CURRY gets chosen then I will pick DURANT. I will add more later but I just needed help getting this to work. Thanks!!
please see picture of my spreadsheet:
Capture.JPG
Bookmarks