Hello,
start with LibreOffice Help - IF - which states that there are 3 arguments required.
- Test - this tests a condition
- What should happen, if the test is TRUE
- What should happen if the test is not TRUE (FALSE)
and the ,
just separates these 3 item from each other. Now it should be easy to analyse each of your formulas:
Formula: IF($Groups.G7="","",$Groups.G7)
- Test:
Groups.G7=""
means look in table Groups
cell G7
, if it is empty
- TRUE:
""
means: don’t show anything , if cell G7
in sheet Groups
is empty
- FALSE:
Groups.G7
means: Show the value of cell G7
in sheet Groups
(since there is one)
Formula: =IF(B5="","",IF(A5=3,IF(H4+18<=B5,"..",IF(H4<=B5,".","")),IF(6+18<=B5,"..",IF(6<=B5,".",""))))
This one is a quite complicated so-called nested IF, which means:
- TEST:
B5=""
- means to test whether cell B5
is empty string.
- TRUE:
""
- show an empty string if B5
is an empty string
- FALSE (an now it get’s hard) makes another distinction:
3.1) TEST: A5=3
test wether cell A5
equals 3
3.2) TRUE: - again makes a differentiation of what to happen
3.2.1) TEST: H4+18<=B5
- test, if adding 18
to cell H4
yields a value less or equal to cell B5
3.2.2)TRUE: “…” means show 2 dots
3.2.3) FALSE: makes the next differentiation
3.2.3.1) TEST: H4<=B5
- test if cell value in H4
less or equal cell value in B5
3.2.3.2) TRUE: show a dot character .
3.2.3.3) FALSE: show an empty string no content)
3.3) FALSE: makes the next differentiation of what to happen
3.3.1) TEST: 6+18<=B5
test if cell B5 greater or equal to
24` (6+18)
3.3.2) TRUE: “…” means show 2 dots
3.3.3) FALSE: makes the next differentiation
3.3.3.1) TEST: Cell content of B5
greater equal 6
3.3.3.2) TRUE: show a dot character .
3.3.3.3) FALSE: show an empty string no content)
This is hard to understand and it is obvious that nested IF
statements should be avoided.