Completely stuck on this Scoring Spreadsheet :(

Hi,

I am not an Excel expert at all, but normally I get by. But I've run into a complete stop on this latest project. It is a game "Scoring" spreadsheet where a "Reference" number is generated for each digit added to an "Index" list.

The parameters are as follows;

1. The "Score" (Reference) adds +1 for each increase of +1 in the Index List
2. The Reference number cannot be more than 9. When it reaches 9 it rolls over to 1
3. If the Index number increases by more than 1, then the Reference number also increases by same amount (to a max of 9, then to 1)
4. If the Index reverses, the "Score" (Reference) must also reverse pro-rata (subject to the max 9 then to 1 rule)
5. The maximum Index number is 359, then it starts at Zero again. The "Score" must be able to maintain integrity in this condition.

So that's it..... I can get it to work fine, providing the Index number only increases in increments of "1" using the following;

=IF(AND(C5=9;B6>B5);1;IF(B6=B5;C5;C5+1))

But it will not work if increments are greater than "1", nor if the numbers reverse, nor if the "359 -0" condition exists

I've tried all sorts, but it is beyond me..... Could any kind soul take a look at it for me and suggest a solution?

Attached is a test Worksheet for reference.


Thanks in advance.....

ChemistB.... What can I say, indeed it worked fine .

I've learned something for sure.... need to think in simple clear terms. I wasted a lot of time thinking way too complicated....lol.

Thanks again... it was appreciated!