HI Guys

Can somebody show me how to do this simple if statement.

say i have two rows A and B

row A has a set of names in like peter, dan, simon etc etc

and

Row B also has a set of names in like peter, dan, simon etc etc

In row C i would like to write a formula like this:

if (RowA = RowB) print RowA Else Print RowB
can anyone help

Cheers in advance


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=567462

Hi

Try this in C2:
=IF(A2=B2,A2,B2)
and fill it down your column

Hope this helps.
Andy.

"digital21st"
wrote in message
...

HI Guys

Can somebody show me how to do this simple if statement.

say i have two rows A and B

row A has a set of names in like peter, dan, simon etc etc

and

Row B also has a set of names in like peter, dan, simon etc etc

In row C i would like to write a formula like this:

if (RowA = RowB) print RowA Else Print RowB
can anyone help

Cheers in advance


--
digital21st
------------------------------------------------------------------------
digital21st's Profile:
http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=567462

=IF(A1=B1,A1,B1)

see if that does the trick.

"digital21st" wrote:


HI Guys

Can somebody show me how to do this simple if statement.

say i have two rows A and B

row A has a set of names in like peter, dan, simon etc etc

and

Row B also has a set of names in like peter, dan, simon etc etc

In row C i would like to write a formula like this:

if (RowA = RowB) print RowA Else Print RowB
can anyone help

Cheers in advance


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=567462