Adding to number to get the cell
 

Hi Guys,

I want to know how can I do this:

I have column A and B and and with this two number, add then and see the
data in the cell

Column A Column B Column C
12 2 I wanto see the values in A12 +2
(A14)
15 10 I wanto see the values in A15 +10 (A25)
35 20 I wanto see the values in A35 +20 (A55)
:
:

Thanks

Adding to number to get the cell
 

Paste this formula in C14 cell
=IF("A"&SUM(A14:B14)="A0","","A"&SUM(A14:B14))

Now copy the C14 cell and paste it for the remaining cells of C Column based
on the A&B Column data.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Maracay" wrote:

Hi Guys,

I want to know how can I do this:

I have column A and B and and with this two number, add then and see the
data in the cell

Column A Column B Column C
12 2 I wanto see the values in A12 +2
(A14)
15 10 I wanto see the values in A15 +10 (A25)
35 20 I wanto see the values in A35 +20 (A55)
:
:

Thanks

Adding to number to get the cell
 

Hi, with this formula I am getting "A14" and I want to get the data that is
in "A14"

Thanks



"Ms-Exl-Learner" wrote:

Paste this formula in C14 cell
=IF("A"&SUM(A14:B14)="A0","","A"&SUM(A14:B14))

Now copy the C14 cell and paste it for the remaining cells of C Column based
on the A&B Column data.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Maracay" wrote:

Hi Guys,

I want to know how can I do this:

I have column A and B and and with this two number, add then and see the
data in the cell

Column A Column B Column C
12 2 I wanto see the values in A12 +2
(A14)
15 10 I wanto see the values in A15 +10 (A25)
35 20 I wanto see the values in A35 +20 (A55)
:
:

Thanks

Adding to number to get the cell
 

Assume that you are having 12 in A1 cell and 2 in B1 cell like the below

A1 cell B1 cell
12 2

Paste this formula in C1 cell

=IF(ISERROR(INDIRECT(IF("A"&SUM(A1:B1)="A0","","A" &SUM(A1:B1)))),"",INDIRECT(IF("A"&SUM(A1:B1)="A0", "","A"&SUM(A1:B1))))

Now copy the C1 cell and paste it for the remaining cells of C Column based
on the A&B Column data.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Maracay" wrote:

Hi, with this formula I am getting "A14" and I want to get the data that is
in "A14"

Thanks



"Ms-Exl-Learner" wrote:

Paste this formula in C14 cell
=IF("A"&SUM(A14:B14)="A0","","A"&SUM(A14:B14))

Now copy the C14 cell and paste it for the remaining cells of C Column based
on the A&B Column data.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Maracay" wrote:

Hi Guys,

I want to know how can I do this:

I have column A and B and and with this two number, add then and see the
data in the cell

Column A Column B Column C
12 2 I wanto see the values in A12 +2
(A14)
15 10 I wanto see the values in A15 +10 (A25)
35 20 I wanto see the values in A35 +20 (A55)
:
:

Thanks

Adding to number to get the cell
 

Hi

One way
=IF(SUM(A1:B1)=0,"",INDEX(A:A,SUM(A1:B1)))

--
Regards
Roger Govier

"Maracay" wrote in message
...
Hi Guys,

I want to know how can I do this:

I have column A and B and and with this two number, add then and see the
data in the cell

Column A Column B Column C
12 2 I wanto see the values in A12 +2
(A14)
15 10 I wanto see the values in A15 +10
(A25)
35 20 I wanto see the values in A35 +20
(A55)
:
:

Thanks

__________ Information from ESET Smart Security, version of virus
signature database 4734 (20100101) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4734 (20100101) __________

The message was checked by ESET Smart Security.

http://www.eset.com