Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a two digit number in One Cell | New Users to Excel | |||
Adding number within a cell | Excel Worksheet Functions | |||
Adding a number to a cell that already has a number. | Excel Discussion (Misc queries) | |||
adding number in next cell | New Users to Excel | |||
adding number only if CDN is displayed in next cell | New Users to Excel |