If statement

J

Jeremy

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
 
G

GSalisbury

Jeremy said:
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
Click to expand...
=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.
 
Top