I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example:

1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and 2
in cell 3.
2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3.

Thanks for your help.

Rob

On Wed, 17 Mar 2010 14:45:03 -0700, Robb27
wrote:

I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example:

1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and 2
in cell 3.
2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3.

Thanks for your help.

Rob


If cell 1 is cell A1 and cell 2 is cell A2, try this formula in cell
3:

=IF(OR(A1="A",A2="A"),A1&A2,IF(AND(ISNUMBER(A1),IS NUMBER(A2)),A1+A2,""))

Hope this helps / Lars-Åke

=IF(COUNT(A1:B1)=2,A1+B1,IF(OR(A1="A",B1="A"),A1&B 1,""))


"Robb27" wrote:

I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example:

1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and 2
in cell 3.
2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3.

Thanks for your help.

Rob

Try this...

=IF(COUNT(A1:B1)=2,A1+B1,IF(OR(A1="A",B1="A"),A1&B 1,""))

--
Biff
Microsoft Excel MVP


"Robb27" wrote in message
...
I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example:

1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and
2
in cell 3.
2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3.

Thanks for your help.

Rob