=IF(ISNUMBER(B1),B1,A1)

HTH Otto

wrote in message
ups.com...
I've hacked at this for a while and can't figure it out. I really need
it for an office project.

What formula do I use for Column C, when:

There are numbers in Column A, but not in all of the cells in that
column.

There are numbers in Column B, but not in all of the cells in that
column.

Every row has a number in either Column A, Column B, or both.

In every row, in Column C:

If there is a number in Column B, show that number in Column C,
otherwise show the number in Column A.

Please help me out, thanks. Reply to the group.

Ron M.