View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default 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