Simple If Statement

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]...
>
> 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
>
>