Structure formulas to make them easier to understand

[EckhardGeerdes]

Hi,
formulas like this in one line are not very easy to read once they get more complicated:

=if(A1=1;"Wahr";"Falsch")

If you want to structure a formula you can do that my typing ALT+Enter and you'll get a line break.

=if(A1=1;[INDENT] "Wahr";
"Falsch"
)


I don't know though how to enter comments and would appreciate you help.
It could be like this but that doesn't work:

=if(A1=1;

"Wahr"; ' Comment: This is true
"Falsch" ' Comment: This is false
)

[zbor]

I have only idea to put that in comment of that cell.
You can't put it within formula.

Also, to meake it easier for you to read formula you can click on part of the formula (For example in IF formula to see what return value if true).
That part will be highlited.

EF5.jpg

[alansidman]

Comments are not inserted as part of the formula, but rather in a comment box linked to the cell. Right click on the cell in question, and click on Insert Comment.