I've been trying to figure this out for an hour and can't get it.
I have a stat "Sack Diff" in Column A. It ranges from -8 up to +8. I have 1346 games in the set. In column B I want to have the answer to Column A multiplied by a number depending on column A's value. As column A's value increases, so does the value it is multiplied by.
For instance, 1.5 would be multiplied by 1. 2.5 would be multiplied by 2. 4 would be multiplied by 5, etc .
Any help. Thanks.