Hey Guys, I need help creating a formula for a DFS Sheet.
If anyone can help I would greatly appreciate it. I will give you an example of what I need.
lets say the sheet is set up like this
A stat category…Lets use Pitchers Woba in this scenario.
In B2 we have a vertical list of all the players Pitchers Woba numbers.
Top score is .137 | An elite marker I have dubbed to be .227 | there is an average of .284 | and the worst is .377
I need to formula to create a score from 1-3. 3 being the best outcome.
So if the player has a score from .137 to .227, they would score a 3
If the player has a score from .228-.284, they would score a 2
If the player has a score worse than .285, they would score a 1
So if play X has a P.Woba of .169….the score outcome should be a 3.
If you want, you can send me a PM, I just need a quick fix and I can’t seem to get this down.