how to enter "e" as excel formula

[indecisive0]

my question is fairly simple, all i want to do is to enter a formul
into a cell to do a simple computation, but i need to know how to ente
the mathematical function "e" into excel format...example: e^2.450
everytime i enter it into this format, i get a "name" error. an
suggestions would be greatly appreciated. thanks

-davi

 

[Alan Beban]

EXP(1) is equal to e

Alan Beban

 

[Peo Sjoblom]

Look at the EXP function in Excel's help

--

Regards,

Peo Sjoblom

my question is fairly simple, all i want to do is to enter a formula
into a cell to do a simple computation, but i need to know how to enter
the mathematical function "e" into excel format...example: e^2.450
everytime i enter it into this format, i get a "name" error. any
suggestions would be greatly appreciated. thanks

-david


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[indecisive0]

woo, thanks for the help. i was almost sure it was EXP, but i was
accidentally writing it as EXP^(some number) instead of EXP(some
number), which was causing the NAME error. thanks for the quick
response, working on a lab that's due in about 10 minutes lol =D

 

[Earl Kiosterud]

Indecisive,

You can set up e as a defined name. Insert - Name - Define. Type e into
the top box, and in the "refers to," put =EXP(1). Click Add. Now you can
use it in cell formulas the way you asked.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

my question is fairly simple, all i want to do is to enter a formula
into a cell to do a simple computation, but i need to know how to enter
the mathematical function "e" into excel format...example: e^2.450
everytime i enter it into this format, i get a "name" error. any
suggestions would be greatly appreciated. thanks

-david


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[David]

True, but far easier to write EXP(2.45) than to define e then have to write
e^2.45. Additionally the latter would execute more slowly (if that
mattered, but could on a large sheet) since it requires an extra operation.

David

 

[Bill Sharpe]

I disagree. Defining e, then using e^2.45 is an elegant solution and makes
the formula more understandable to mathematicians. If you have a number of
these operations in your spreadsheet, it's easier too -- two less
keystrokes(including the shift key for entering the ^) than EXP(2.45).

Bill

 

[Bernard Liengme]

I disagree! All mathematicains knwo waht exp(x) means.
Anyway, Excel is for real people like chemists and engineers, not
mathematicians - they can play in Maple-land
Bernard

 

[Peo Sjoblom]

LOL!

--

Regards,

Peo Sjoblom

I disagree! All mathematicains knwo waht exp(x) means.
Anyway, Excel is for real people like chemists and engineers, not
mathematicians - they can play in Maple-land
Bernard