Logiacl function with multiple conditions

I understand your suggestion, but wouldn't I have to include a lookup
for evey possible option? Wouldn't an IF or an IFAND statement be more
appropriate? I would like to be able to just enter one formula to cover
all of the percent ranges and point possibilities.

Thanks in advance!!


--
stellarblue11

I tried both and was unfortunately unsuccessful. I am totally confounded
by this seemily simple problem!

The lookup table, returned only the ', telling me that no matter what %
was referencing excel was just recognizing it as 0. The IF statement
returned 2 pts for a YOY % change of 146.3%, which was the same problem
I was running into initially.

Is excel perhaps referencing the value of the % change formula instead
of it's result?


--
stellarblue11