I'm a home user with not a lot of spreadsheet experience.
I've got a graph that includes a mean average line. I'd like to take the
value of that line (e.g. MV=180) and use it in a formula (e.g. x=4*MV+16)
and use that answer to populate a field.
How do I get MV into the formula?
--
View this
I'm a home user without a lot of spreadsheet experience.
I have a graph with several lines. I'd like line 1 set so that when I enter
a value in the box, that value would stay black if between an upper and
lower limit (e.g. 50-100) and to change to a red font if outside that limit.
Then line 2
Sorry, I ment to insert an image.
The red at the top is just a reminder to me of what the limits are.
http://nabble.documentfoundation.org/file/n4136261/23.png
--
View this message in context:
http://nabble.documentfoundation.org/Font-color-based-on-value-tp4136260p4136261.html
Sent from
I might as well add the chart too. You can see the mean average of the red
graph at 184 (currently).
http://nabble.documentfoundation.org/file/n4136262/07_PM.png
--
View this message in context:
http://nabble.documentfoundation.org/Font-color-based-on-value-tp4136260p4136262.html
Sent from
Here is a screenshot of the graph I have. Notice the mean value line
currently located at 184 on the Y axis.
http://nabble.documentfoundation.org/file/n4136263/07_PM.png
--
View this message in context:
http://nabble.documentfoundation.org/Using-mean-Average-in-formula-tp4136259p4136263.html
wrote:
At 22:37 15/01/2015 -0700, Emil Payne wrote:
I'm a home user without a lot of spreadsheet experience.
No worries!
I have a graph with several lines. I'd like line 1 set so that when I
enter a value in the box, that value would stay black if between an
upper and lower limit (e.g. 50-100
There are times when I copy paste from websites to Calc. Things like
lists of TV stations or Twitter followers.
When I do so it also captures all the images and pastes them to the
document.
This causes a big mess since most of the images cover each other and do
not align with their
On 14/03/15 10:34 AM, Gordon Burgess-Parker wrote:
I'm using LO 4.4.0.3 on Xubuntu 14.10.
I would like to create a document in Writer with a graphical border.
Is there any way of doing this?
Thanks
Gordon
FORMAT PAGE BACKGROUND as GRAPHIC
Fiddle from there. Reset your margins to
On 19/03/15 08:28 PM, James wrote:
Column A has text strings that are DD/MM/ format.
I want to make them real dates.
I tried these 2 datevalue formulas but I can't make it work.
14/03/2015Err:502
14/03/2015Err:502
=DATEVALUE(TEXT(A1,##/##/))
=DATEVALUE(A2)
Highlight the
On 05/17/2015 06:07 AM, Gilles wrote:
Hello
Someone I know heads a non-profit organization, and needs a small database
to manage membership and inventory (stock).
Before building new databases, are there ready-to-use solutions?
Thank you.
--
View this message in context:
On 05/17/2015 06:07 AM, Gilles wrote:
Hello
Someone I know heads a non-profit organization, and needs a small database
to manage membership and inventory (stock).
Before building new databases, are there ready-to-use solutions?
Thank you.
--
View this message in context:
On 05/21/2015 04:13 AM, Michael Wu wrote:
Dear all,
In Libreoffice Calc 3.6, the line color of the comments is
black. But in Libreoffice Calc 4.3.7, the color is changed. Although we
can change the color back to black by Right click the comment --
click [Line] -- change the color, it
On 10/31/2015 07:57 AM, Regina Henschel wrote:
Hi Daniel,
Daniel schrieb:
Just enquiring, can one instead of writing 4 business cards on one page,
(where they are all the same), creating each one differently but on the
same page?
Daniel
You can use File > New > Label. That wizard has the
13 matches
Mail list logo