Help an amateur create a formula?

[Scott Willing]

Howdy,

Total Excel amateur seeks your expertise.

What is the correct syntax to enter the following formula, spelled out
for clarity (I hope):

2 times (10 raised to the power of (x/29.5 - 3.3))

where "x" will be a certain cell?

TIA,
-=s

 

[Jim]

=[10^{((x/29.5)-3.3)}}*2

chek if it works!

 

[Scott Willing]

N'mind, got it.

"POWER" is the bit I was missing.

-=s

 

[JE McGimpsey]

Assuming your "certain cell" is A1, one way:


=2 * 10^(A1/29.5 - 3.3)

 

[Scott Willing]

Thanks for the responses, so fast that I couldn't call off the hunt in
time.

Feel goofy. Should've tried the caret thing but since I use Excel for
calculation so rarely I just assumed that there had to be some
function. Finally found POWER in the help file and it mentions the use
of the caret.

Cheers!
-=s