Equation

[zephyr]

I would like to do the following equation in excel. Can anyone assist with
the formula required to complete this is excel.

x = a x 10^9e^ -b/(c+273.15)

The following are variables:

a = 2.8
b = 7.8
c = 60

b is a minus number

Many thanks in advance

Zephyr

 

[Lars-Åke Aspelin]

I would like to do the following equation in excel. Can anyone assist with
the formula required to complete this is excel.

x = a x 10^9e^ -b/(c+273.15)

The following are variables:

a = 2.8
b = 7.8
c = 60

b is a minus number

Many thanks in advance

Zephyr

What do you mean by "b is a minus number"?
b = 7.8

For the expression, do you mean

x = a * 10^9 * e^(-b/(c+273.15)) (alternative 1)

or

x = (a * 10^9 * e^-b ) / (c+273.15) (alternative 2)


Here are the forumulas
(assuming a is in cell A1, b in B1 and c in C1)

= A1*10^9*EXP(-B1/(C1+273.15)) (alternative 1)

= (A1*10^9*EXP(-B1))/(C1+273.15) (alternative 2)


Hope this helps / Lars-Åke

 

[zephyr]

Lars

Alternative 1 works fine.

Many thanks

Zephyr