G
Guest
How do I enter and exponential equation in a cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
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
=2^2 for squared
=2^3 for cubed
=2^1.7
Gord Dibben MS Excel MVP
G
Guest
=2.71828183^A1
G
Guest
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
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
R
Rick Rothstein \(MVP - VB\)
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
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
D