Is it possible to show cell value with text

users
#1

Is it possble to do the following:

Lets say a1 =5, a2=3 and a3=7, now in cell c1 I would like a message to say
"Number of errors are " + (=sum(a1:a3) +"."
Number of errors are 15.

Is this even possible?

Thanks ahead for any suggestions.

#2

Nice easy one that! You were nearly there:

="Number of errors are " & (SUM(A1:A3) &".")

#3

Thanks for the solution.

#4

How can we give you a solution when you have not yet given us the problem? It appears that you are using Calc. But what to you mean by show cell value"? Where is the text located? Are you referring to a cell containing twenty-seven rather than 27 for example? Or perhaps ten november two thousand twelve instead of 10 Nov 2012 or Nov 10, 2012?
      Please be more specific.

--Dan

#5

This was a thread from 5th November which I answered to the group. He
thanked me but got fooled by the stupid group reply settings.

#6

Hi John,

Checked your reply on list-archives :slight_smile:
Somehow must have missed on 6th Nov when it first appeared.

Please, what is the & stand for? 
Dave_ had asked the question with a +

So, I guess this is some standard way of doing things(name?) with slightly diff syntax.

I have never known it can be done that way - text and formula together in a cell.

I have always used adjacent cells - one with the text part and another with the formula.

Any pointers would be great.
 
Thanks,
Regards,
Viral Orpe :slight_smile:

#7

The & concatenates text strings whereas + tries to add them and fails!

#8

Thanks Johnny,

Season's Greetings!!
(Today we are celebrating Diwali Festival and New Year here - India)

I would like to know what is this language used to talk to Calc?
And would appreciate any pointers to any literature, guides etc.

I know C and have worked with formulas - this combination is new to me.

I am not sure what you are asking. So far in this thread we have only
talked about cell formulas, as far as I have seen. Those are the same
as those in Excel, at least most of them.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

#9

Hi Johnny,

May be I should go through Calc documents/ How to use Calc or something similar!

I have used Excel/Calc in a hands on approach - using the drop down menu
one gets after clicking the = sign for entering a formula, a generous use of F1,
exploring the menus/ icons on tool-bar and of course, Google.

So, (now it seems, obviously) I do not know the full capabilities of either software.
I may not have needed/ used/ or thought possible many aspects/ functionalities of these
applications that are "standard practice" for most users! And, hence the confusion.
 
Got to get back to the basics.... :slight_smile:

Thanks anyways,

Regards,
Viral Orpe :slight_smile:

#10

http://wiki.documentfoundation.org/Documentation/Publications

Download the Calc Guide from this link. It may help.

--Dan

#11

Thanks Dan,

Link/Guides look good :slight_smile:

Regards,
Viral Orpe