change the formula by changing contents of cell
Maybe you can incorporate a multiply in your formula:
* 1 for when you select walks, and
* -1 for when you select strikeouts.
If you supply your formula then we can see how this could be included.
Hope this helps.
Pete
On Feb 19, 4:31*pm, AJSloss wrote:
I have a table that ranks a list of players by their statistics, for example,
when I change cell B2 to "walks", my formula (large) lists the player with
the most walks in cell B4, 2nd most in B5, 3rd in B6... *that works well
because more walks are good. *But, when I change cell B2 to "strikeouts" I
want it to list the player with the fewest number of strikeouts in B4, next
fewest in B5 and so on.
Is there a way to change the "large" function to the "small" function within
the formula? *
I have set up a helper cell (C2) that changes from "large" when I have
"walks" in B2 to "small" when I have "strikeouts" in B2.
|