Check one cell, check second cell, return relevant value

Have used this forum but only for searching posts with replies that solve my problem before now.

I'm struggling with a formula that I think should be easy but I can't figure:

I have two columns of data (A&B): I want to add a third column (C) whereby each cell in that column will check its respective row data in A&B.
If it finds no data in column A, then I want it find that data in column B & return that, if however there is no data in either A or B I want it to return a blank"".

Hope I've described my problem & would appreciate some help.

Thanks,
Ian

Try

=IF(A2="",IF(B2="","",B2),A2)

Excellent. Thanks for the extremely speedy response & solution

You're welcome..

It might be simplified if your expected return value is TEXT, not number..

=T(IF(A2="",B2,A2))