Using a complex IF-THEN formula I want to rotate an angle only under certain circumstances. Otherwise, the angle should remain unchanged. My formula gives me the result I want, but Seamly gives me something strange in the formula editor: Formula: -1e-05º. Does anyone have any idea what this means? Google can’t help me without the right keyword.
Hello, @Dina
I see this quite a lot in Excel when the result is 0.000000001 and I have the column set to “General”. If I set the column to “Numbers” with 2 decimals, it gives me 0.00.
However, I’ve never actually Googled it , which I did now and this is what it tells me:
Another reply is: The meaning of e in python is 10 ** -5, i.e. 10 to the power of negative 5, 1 divided by 10 to the power of 5, or 0.00001.
Basically, it’s telling you that the result of your IF formula is 0°.
Thank you very much!
Just in case someone has this issue in the future, for extra precision:
-1e-05° = -1*10^(-5) = -0.00001°
The minus sign stays there.
It’s called scientific or E(xponential) notation. When numbers get very large or very small, it’s easier represent them as a few digits times 10 to some power. So something like .000000000000001… is easier to read as 1.0E-15 or 1 moved 15 decimals to the right.
The default display format in Seamly is to dsiplay 6 char places or E notation… which ever is more compact. So 1e-05º would represent a VERY SMALL angle of .00001 degrees.
If we change it to .0001 or 5 chars, then it displays:
While you can use E notation in the formulas and the math parser will understand it,
Very large number will display with a E+
you generally should only run across the app displaying a value, unless you like using E notation.
He he… I was trying to illustrate how the display switches to E notation with 6 chars, and I’m going why is it not displaying -1E-05… when I realised I was using my 15 decimal build from the other topic. Doh.