Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2007

Tip: Looking for answers? Try searching our database.

Exponential equations

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dianamath161 - 20 Oct 2007 18:41 GMT
How do I enter and exponential equation in a cell?
Gord Dibben - 20 Oct 2007 19:53 GMT
Use the Caret found on 6 key above qwerty keys

=2^2  for squared

=2^3  for cubed

=2^1.7  

Gord Dibben  MS Excel MVP

>How do I enter and exponential equation in a cell?
Gary''s Student - 20 Oct 2007 19:59 GMT
=2.71828183^A1
Signature

Gary''s Student - gsnu200750

> How do I enter and exponential equation in a cell?
Dave Peterson - 20 Oct 2007 20:16 GMT
or
=exp(2)

> =2.71828183^A1
> --
> Gary''s Student - gsnu200750
>
> > How do I enter and exponential equation in a cell?

Signature

Dave Peterson

Joel - 20 Oct 2007 20:01 GMT
General for of an exponential is

Y = (A*x^2) +( B*x^1) + C

putting in numbers

= (5 * (A1^2))+(2.4*(A1^1))+5.6
wher A1 is cell A1

You

> How do I enter and exponential equation in a cell?
Rick Rothstein (MVP - VB) - 20 Oct 2007 20:09 GMT
> How do I enter and exponential equation in a cell?

Another possibility is to use the POWER function. Using references...

=POWER(A1,B2)

or using constants...

=POWER(3,5)

or you can use a combination of the two.

Rick
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.