Assign values to both A2 and A3

's Computer Specifications

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

's Computer Specifications

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 Removed)DTHIS
www.nickhodge.co.uk

"mickie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign values for one column to another.	Celticshadow	Microsoft Excel Discussion	8	17th Oct 2008 10:01 AM
HELP PLS!! -- assign values into combo box	=?Utf-8?B?c2lMdmVy?=	Microsoft Access Getting Started	2	28th Jun 2006 03:36 PM
assign values from 1st tbl to 2nd tbl	=?Utf-8?B?VGlt?=	Microsoft Access VBA Modules	7	26th Aug 2005 04:51 PM
Logically assign values	=?Utf-8?B?TFA=?=	Microsoft Access Reports	1	29th Jul 2005 09:54 PM
Cant assign array values ! ? ! ?	Chris Wertman	Microsoft VB .NET	7	19th Apr 2004 11:14 PM