Assign values to both A2 and A3

M

mickie

Using =If((A3=A2),"X","O") It assigns "X" for the A2 and and
"O" for the A3. How can get it to also assign an "X" for the A3?
Thanks
Mickie
 
N

Nick Hodge

Mickie

Not quite with you. That formula will assign an X in the *cell it is in* if
A3=A2, else it will assign a O in that cell

BTW: parenthesis are not required around the A3=A2 ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
Top