Assign values to both A2 and A3

  • Thread starter Thread starter mickie
  • Start date Start date
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
 
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
(e-mail address removed)
www.nickhodge.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

***Help on writing a vba code 12
Copy & Paste 1
Serious bug in order of evaluation? 1
Duplicating cells with formula's 3
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Access Window Access Table overwirte? 1
Simple "If" Function - HELP 6
Data Validation and drop-down list using IF, AND and what else? 8

Back
Top