If statement

[Guest]

Could someone help me write an if statement saying that if the current cell
has no data in it to place a o in the cell but if there is a number do
nothing.

Thank you

 

[GSalisbury]

Could someone help me write an if statement saying that if the current cell
has no data in it to place a o in the cell but if there is a number do
nothing.

Thank you

=if(a1="",o,a1)
is [basically] what you want but will most likely produce a looping error.
I had a similar scenario and was steered to Tools/Options/Iteration control.
That worked for my needs.