Thread: Adding to number to get the cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default 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 With QuoteReply With Quote