E.CONST

Returns the value of Euler’s number.

Syntax:

E.CONST()

Example:

E.CONST()

returns 2.718281828

E.CONST() =

2.718281828

Application:

Calculating the Current from a Flow of Electrons

Scenario: An electron beam in a cathode-ray tube (CRT) is used to create an image. We want to calculate the current generated by this beam, given the number of electrons passing a point per second.

E is a placeholder for the elementary charge constant, which is approximately 1.602176634×10−19 Coulombs. It's often used in conjunction with other variables to calculate quantities like current or energy.

Table:

	Variable	Description	Value
	A	B	C
1	N	Number of electrons per second	6.2415×1018 electrons/s
2	e	Elementary change	1.602176634×10−19 C
3	I	Current	?

Formula:

The current (I) is defined as the amount of charge (Q) passing a point per unit of time (t). Since Q is the number of electrons (N) multiplied by the elementary charge (e), the formula becomes:

I=Q/t=(N×e)/t

In this case, since N is already given as "electrons per second," the time (t) is 1 second, so the formula simplifies to:

I=N×e

The result for I would be approximately 1 Ampere.

Explanation:

The value of N is the rate of electron flow.
The value of e is the fundamental constant, which is a fixed value. In a real-world spreadsheet, you would either hard-code this value or use a named range to refer to it as e.const.
The formula I = N * e calculates the total charge passing per second, which is the definition of current.