First, is there a way to get a constant like pi? Or should we just put as many digits as we can.
Second, is there a guide to the conditional formatting? I remember seeing someone use it once but I’m not familiar with it. I know it involves a “?” and multiple outputs
1 Like
Yes.
1 Like
To get pi, you can use the expression:
Math.PI
or, just use:
3.14159
The expression you are thinking of is called the ternary expression.
3 Likes
As well, I have a library of commands that will work in the expressions.
Not just math, but also number manipulations
3 Likes
what does floor, ceil, min and max do?
1 Like
Floor and Ceil (ceiling) are just the technical terms for round down and round up.
Max and Min just picks the highest and lower values, good for needing min or max on 2 independent values (though I rarely use them).
2 Likes