Simple If Statement

[digital21st]

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

 

[Guest]

Hi

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

Hope this helps.
Andy.

"digital21st" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

=IF(A1=B1,A1,B1)

see if that does the trick.