Help with an "if" function pls

[Michael N]

Hi
I'm trying to work out the formula for this function & was wondering if anyone can help me

if(A1:A2 ="","",)if(A1="",A2=X,"O")if(A1=X,A2=X,"X")

 

[DanteAmor]

In which cell the formula goes.
You can explain with your words what you have in A1 and what you expect from the result.

 

[Michael N]

What I have is 3 cells eg: A1,A2,A3
In A3 I would like to show if A2 only has an X in it with an "O" but if both A1 & A2 have an X to show an "X". If both are blank, not to show anything
The cell A3 is Conditional Formatted to show different colours if either X or O

 

[DanteAmor]

tRY:

=IF(AND(A1="",A2=""),"",IF(AND(A1="X",A2="X"),"X",IF(AND(A1="",A2="X"),"O","Not specified")))

 

[Michael N]

That's it works great
Thank you for you speedy help & reply Dante Amor

 

[DanteAmor]

I'm glad to help you. And thanks for the feedback.