Hi,
I have a cell say N1, in which I am supposed to write something which will look like this:
Now the number 5421 is generally a sum of series of cell, for example:![]()
Please Login or Register to view this content.
For now I calculate the sum in a temp. cell and then manually write the sum (5421) in the N1 cell's formula bar.![]()
Please Login or Register to view this content.
Now how can I do the same without using the temp cell i.e. can I use a Text and a Formula together in the same cell?
Thanks
Bookmarks