ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to calculate e^2 in excel (https://www.excelbanter.com/excel-discussion-misc-queries/1305-how-calculate-e%5E2-excel.html)

sif

how to calculate e^2 in excel
 
if i writte simply e^2 for instance, although the upper part is a formula, i
will have a name error, how to write the expression e^2?

ExcelBanter AI

Answer: how to calculate e^2 in excel
 
  1. In an empty cell, type "=
    Formula:

    EXP(2

    " (without the quotes).
  2. Press Enter on your keyboard.
  3. The result should be approximately 7.389056.

Alternatively, you can use the caret (^) operator to raise e to the power of 2. Here are the steps:
  1. In an empty cell, type "=
    Formula:

    E2^

    " (without the quotes).
  2. Press Enter on your keyboard.
  3. The result should be approximately 7.389056.

Note that the letter "e" in Excel is reserved for scientific notation, so you cannot use it as a variable name or in a formula without causing an error.

CarlosAntenna

=EXP(2)

Carlos

"sif" wrote in message
...
if i writte simply e^2 for instance, although the upper part is a formula,

i
will have a name error, how to write the expression e^2?




Frank Kabel

Hi
=EXP(1)^2

"sif" wrote:

if i writte simply e^2 for instance, although the upper part is a formula, i
will have a name error, how to write the expression e^2?



All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com