Formula: -1e-05º

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. grafik

1 Like

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 :grinning: , which I did now and this is what it tells me:

image

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°.

1 Like

Thank you very much!

1 Like

Just in case someone has this issue in the future, for extra precision:

-1e-05° = -1*10^(-5) = -0.00001° :wink:

The minus sign stays there.

3 Likes

Thank you very much, @Onetchou. Solving this helped me to solve the other topic :confounded: :star_struck:

1 Like

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.

image

If we change it to .0001 or 5 chars, then it displays:

image

While you can use E notation in the formulas and the math parser will understand it,

image

Very large number will display with a E+

image

you generally should only run across the app displaying a value, unless you like using E notation. :slight_smile:

3 Likes

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.

2 Likes