[Kaplan]

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.

[jrs362]

You could use:

=IF(A1=1.5,A1*1,IF(A1=2.5,A1*2,IF(A1=4,A 1*5)))

Adjust it to include all the possible values from Column A and what you want the multiplier to be.

[Kaplan]

You could use:

=IF(A1=1.5,A1*1,IF(A1=2.5,A1*2,IF(A1=4,A 1*5)))

Adjust it to include all the possible values from Column A and what you want the multiplier to be.

Thanks Brother. I was using =IF, but was leaving the =signs inside the formula out.