IF THEN ELSE in a spreadsheet?

[kc79]

Heyho,


Do the spreadsheet may work with " if then else" stuff?



Br kc

[eivindkvedalen]

Heyho,


Do the spreadsheet may work with " if then else" stuff?

Yes, it's similar to the conditional operator in C: <test> ? <true-branch> : <false-branch>

Example: = (A1 > A2) ? 1 : 2

...will give 1 if A1 > A2, and 2 otherwise.

Eivind

[kc79]

Thx

[ceremcem]

This doesn't work in FC 0.17:

Screenshot_2018-09-22_16-35-00.png (117.14 KiB) Viewed 2983 times

[chrisb]

You necrobumped a rather old topic. Consider to open a new and reference the old. Now for your issue:

Omit the brackets, i.e. write

Code: Select all

=B1 > 2 ? 1 : 2

I could have used a screenshot to show this, but writing such things as plain text has two advantages: It saves bandwith! Your image consumes 117.14 Kilobytes, which is approximately 1000 times the size some text would need.

The second reason is, that your image cannot be searched by other users having the same problem.

[ceremcem]

Omit the brackets, i.e. write

Code: Select all

=B1 > 2 ? 1 : 2

Thanks Chris, that worked.

You necrobumped a rather old topic. Consider to open a new and reference the old.

Searches directly led me to the topic, so I thought someone else would also come here, which in turn made sense to resume the thread.

I could have used a screenshot to show this, but writing such things as plain text has two advantages: It saves bandwith! Your image consumes 117.14 Kilobytes, which is approximately 1000 times the size some text would need.

I've never seen that the bandwidth was a problem before, anyway, I had no choice this time because there were no error messages in the output. I'm filing a bug for this.

The second reason is, that your image cannot be searched by other users having the same problem.

In this particular context, I think previous content is quite enough for further searches (as I found the topic by google search).

Sorry for any inconvenience, it'll take some time to get used to the FreeCAD forum.