[Solved] Excel formula for cellular automata rules

[Melissa_23]

Hello there
In the attached image I'm trying make a formula for the following rules in open office calc with a cellular automata mathematical equation.

So far I have done this:

=IF(AND(D4='S',OR(C4='S', E4='S')),'O', IF(AND(D4='O',OR(COUNTIF(C4:E4;"<>O"))),'O','S'))

It keeps coming up with an error #508 or #REF! and I'm really stuck of where exactky I'm going wrong.
If anyone has any ideas it's be very much appreciated

[FJCC]

If you are really using OpenOffice Calc and not Excel, then the parameters in your formula need to be separated by semicolons and not commas. Also, text has to be surrounded by double quotes. Try

Code: Select all

=IF(AND(D4="S";OR(C4="S"; E4="S"));"O"; IF(AND(D4="O";OR(COUNTIF(C4:E4;"<>O")));"O";"S"))

This part of the formula doesn't make sense to me

Code: Select all

OR(COUNTIF(C4:E4;"<>O"))

OR() with only one argument is no different that just using the argument.

[MrProgrammer]

Hi, and welcome to the forum.

I'm trying to write up an excel formula …

This forum is for Calc, not for Excel. For Calc, assuming g(x-1), g(x), and g(x+1) are in C4, D4, and E4, use =IF(ISODD(COUNTIF(C4:E4;"S"));"O";"S").

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[Melissa_23]

Thanks so much for your help