Picking numbers from 2 columns - need help
 

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.

Picking numbers from 2 columns - need help
 

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

Picking numbers from 2 columns - need help
 

In C1:
=if(B1<"",B1,A1)
then drag fill down the column

--
Regards,
Tom Ogilvy



" wrote:

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.

Picking numbers from 2 columns - need help
 

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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.

Picking numbers from 2 columns - need help
 

Reading some of the other responses, mine would only work if the non numeric
cells were blank (which was what I envisioned).

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote:

In C1:
=if(B1<"",B1,A1)
then drag fill down the column

--
Regards,
Tom Ogilvy



" wrote:

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.

Picking numbers from 2 columns - need help
 

Thanks, guys. You'll never pay for a drink when I'm around.

Ron M.