I am writing an application that recreates Cellular Automaton. As you can see from the link it uses a grid concept and therefore I thought Excel would be a good structure to start on. My solution is an inverted version of the one you see in the link and utilises a function that uses two parameters, the "cell" to the left and the "cell" to the right (the parents), by comparing there values I can produce the desired result and place it in the cell directly below them
Feeling happy that I had created this model I decided to progress the mathematics behind it and added a new rule, the rule of mutation. My idea was to say that if the parent, grand parent and great grand parent of a given cell were the same in either direction then the cell would "mutate" and create a different value. Getting stuck I created a function that uses 6 parameters, a bit cumbersome, but again worked and I got the desired result.
Now to my question (phew)
I would like to streamline this function so that it only uses two parameters ( the parents) and use the function to calculate the other 4 cells, I tried to use offset.value but got a circular reference, any ideas?