Re: [libreoffice-users] Formula and text in same cell?

Would insert -> comment be of help?


On 11/20/2017 09:47 PM, Brian Barker wrote:
> At 20:04 20/11/2017 -0500, Dotty Carl wrote:
> > In a cell, let's say A1, ...
>
> I don't see that matters ...
>
> > ... there's a formula such as =DayNum(Z1, Z3). I'd like to also put 
> > text in the same cell.
>
> So what do you want to have displayed in that cell? Any formula 
> defines what is displayed. What would be the function of the 
> additional text?
>
> > How can this be done?
>
> If you need a function reference, as here, but want the displayed 
> result to contain additional material, you need to include that 
> material inside the formula containing the function. You can 
> concatenate text with a function result using the CONCATENATE() 
> function, or more simply using the "&" operator. Any non-text value, 
> such as a number, is implicitly converted to text to enable this. For 
> example,
> =SQRT(3+1)
> displays
> 2
> whereas
> ="The square root of 3+1 is "&SQRT(3+1)&"."
> displays
> The square root of 3+1 is 2.
>
> I trust this helps.
>
> Brian Barker

--
********************************
A smile - is a sign of joy.
A hug - is a sign of love.
A laugh - is a sign of happiness.
And a friend like me??
...that's just a sign of good taste!!

Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted