Ask Your Question

Laniakea's profile - activity

2019-03-14 21:32:46 +0200 received badge  Popular Question (source)
2019-03-14 15:46:34 +0200 received badge  Notable Question (source)
2019-03-14 11:16:04 +0200 received badge  Notable Question (source)
2019-03-14 08:55:58 +0200 edited question [SOLVED]Finding matching value

[CLOSED]Finding matching value Hello! I have trouble figuring out how to get the corresponding value for cell H11 to ap

2019-03-14 08:55:35 +0200 edited question [SOLVED]Finding matching value

Finding matching value Hello! I have trouble figuring out how to get the corresponding value for cell H11 to appear in

2019-03-14 08:54:28 +0200 edited question [GESCHLOSSEN]Bearbeitung und Darstellung von wissenschaftlichen Daten

Bearbeitung und Darstellung von wissenschaftlichen Daten Hallo! Mich würde mal interessieren ob es möglich ist so Dinge

2019-03-14 08:53:20 +0200 asked a question Different colors for databar

Different colors for databar Hey there! Does an option exist that can turn the databar different colors for certain ran

2019-03-14 08:22:39 +0200 edited question [SOLVED] Only average if cells contain a certain word

Only average if cells contain a certain word Hello! In this example I'd like F7 to calculate the average time of the ra

2019-03-05 21:49:10 +0200 received badge  Popular Question (source)
2019-03-05 09:31:57 +0200 asked a question [SOLVED] Only average if cells contain a certain word

Only average if cells contain a certain word Hello! In this example I'd like F7 to calculate the average time of the ra

2019-02-27 21:10:19 +0200 received badge  Popular Question (source)
2019-02-27 16:30:22 +0200 edited question [SOLVED]Conditional formatting on cells using containing "CONCATENATE"

[SOLVED]Conditional formatting on cells using containing "CONCATENATE" Hey there! I'm having trouble getting conditiona

2019-02-27 16:30:22 +0200 received badge  Editor (source)
2019-02-27 16:30:15 +0200 edited question [SOLVED]Conditional formatting on cells using containing "CONCATENATE"

Conditional formatting on cells using containing "CONCATENATE" Hey there! I'm having trouble getting conditional format

2019-02-27 16:29:59 +0200 commented answer [SOLVED]Conditional formatting on cells using containing "CONCATENATE"

Wow how did I not know this feature sooner. It's so much more elegant. THANK YOU!!! :)

2019-02-27 16:21:17 +0200 commented answer [SOLVED]Conditional formatting on cells using containing "CONCATENATE"

So C7 should just be reduced to =SUM($C$3:$C$5) and format that cell with [=1]0" Ball";0" Balls" ?

2019-02-27 16:20:10 +0200 commented answer [SOLVED]Conditional formatting on cells using containing "CONCATENATE"

So C7 should just be reduced to =SUM($C$3:$C$5) and the format that cell with user-defined settings? If I want to add th

2019-02-27 16:09:11 +0200 marked best answer [SOLVED]Conditional formatting on cells using containing "CONCATENATE"

Hey there!

I'm having trouble getting conditional formatting to work on cells that link to another which contain the "concatenate" formula.

I have one sheet named "overview" at the beginning of my spreadsheet where I copied the results of the other sheets, so I don't have to click on each individual sheet to see the data I want.

For example I have two sheets named "Red" & "Blue" that contain a list of the date and amount of balls sold.

image description

The formula for C7 is =IF(SUM($C$3:$C$5)>1;CONCATENATE(SUM($C$3:$C$5);" Balls");CONCATENATE(SUM($C$3:$C$5);" Ball"))

C7 works as I intended, it displays the Sum of C3,C4 & C5 and adds "Balls" if the sum is greater than 1, if not it adds "Ball" to the sum.

I copied/linked that cell with value of C7 into my "overview" sheet where I also copied the C7 value of the "Blue Balls" sheet.

They're cells C4 & C5 in the overview sheet. image description

Now I want to conditional format these two cells so that the MAX & MIN value of C4 & C5 are colored red/green but when I try that with "cell value > is equal to > MIN($C$4:$C$5)" it doesn't change the color of the cells.

I figure that is because C4 & C5 aren't considered "numbers" by LibreOffice calc and instead are treated as text or something.

Does anybody know how to fix this or work around this?

2019-02-27 16:09:11 +0200 received badge  Scholar (source)
2019-02-27 15:53:32 +0200 asked a question [SOLVED]Conditional formatting on cells using containing "CONCATENATE"

Conditional formatting on cells using containing "CONCATENATE" Hey there! I'm having trouble getting conditional format

2019-01-24 00:37:41 +0200 received badge  Popular Question (source)
2019-01-23 11:01:32 +0200 commented question [SOLVED]Finding matching value

EDIT: I figured out my mistake. =INDEX($B$3:$B$17;MATCH(H11;$E$3:$E$17;0)) fixed it

2019-01-23 09:49:11 +0200 asked a question [SOLVED]Finding matching value

Finding matching value Hello! I have trouble figuring out how to get the corresponding value for cell H11 to appear in

2019-01-23 09:24:25 +0200 received badge  Famous Question (source)
2016-08-08 10:13:32 +0200 received badge  Notable Question (source)
2016-03-08 13:49:47 +0200 received badge  Popular Question (source)
2016-02-14 15:37:07 +0200 received badge  Enthusiast
2016-02-09 17:29:53 +0200 asked a question [GESCHLOSSEN]Bearbeitung und Darstellung von wissenschaftlichen Daten

Hallo!

Mich würde mal interessieren ob es möglich ist so Dinge wie die Standardabweichung, Variationskoeffizient, prozentualer Fehler etc. mit LibreOffice Calc graphisch darzustellen?

Außerdem habe ich ein Problem gefunden, wenn ich Werte in ein Diagramm einzeichnen lassen möchte, von denen ich nur den Y-Wert kenne und den X-Wert graphisch ablesen möchte.

Hab mal meine Datei hier hochgeladen. Es geht um die orange markierten Werte. So wie es momentan ist, stimmt es nicht, weil die unbekannte Lösung 2 mit einer Dichte von 1,044 g/cm³ nicht 4%ig sein kann!

Wie ich die Abweichung der blau markierten Reihe zu der Ausgleichsgeraden in rot ermitteln und darstellen kann würde ich auch gerne wissen.

Freue mich auf Vorschläge/Anmerkungen sowie Tips & Tricks von Leuten, die bereits in einem Bereich arbeiten, wo sie Daten auswerten müssen.

Beste Grüße,

Laniakea