Prev: multiplying fractions
Next: Excel 2007
From: via135 on 6 Mar 2010 09:57
hi all!

i have to update a workbook on daily basis.
today I am having values from A1:A3 as 50,60,70
& B1:B3 10,20,30. while updating tomorrow i will
change only the values in B1:B3 to 20, 30 & 40 and doing so
the values in A1:A3 should change as A1+B1, A2+B2 & C1+C2
ie) 70,90,110. the next day the values in B1:B3 will be changed
into some other values and A1:A3 should show the value
as A1+B1, A2+B2 & C1+C2

is it possible by any worksheet function or else..?

hlp pl..!


-via135


From: joel on 7 Mar 2010 07:57

You need to concatenate two string together and put a p;us sign
inbetween the two cell references

=A1&"+"&A2


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=185203

[url="http://www.thecodecage.com/forumz/"]Excel Live Chat[/url]

From: via135 on 7 Mar 2010 09:54
On Mar 7, 5:57 pm, joel <joel.47g...(a)thecodecage.com> wrote:
> You need to concatenate two string together and put a p;us sign
> inbetween the two cell references
>
> =A1&"+"&A2
>
> --
> joel
> ------------------------------------------------------------------------
> joel's Profile: 229
> View this thread:http://www.thecodecage.com/forumz/showthread.php?t=185203
>
> [url=&quot;http://www.thecodecage.com/forumz/"]Excel Live Chat[/url]
hi joel,
i will
change only the values in B1:B3 to 20, 30 & 40 and doing so
the values in A1:A3 should change as A1+B1, A2+B2 & C1+C2
ie) 70,90,110. the next day the values in B1:B3 will be changed
into some other values and A1:A3 should show the value
as A1+B1, A2+B2 & C1+C2

-via135
 | 
Pages: 1
Prev: multiplying fractions
Next: Excel 2007