Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |