Help an amateur create a formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Willing - 27 Oct 2004 19:00 GMT

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

Reply to this Message

Jim - 27 Oct 2004 19:09 GMT

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

chek if it works!

Signature

Hope it Helps!
Jim
India

> Howdy,
>
[quoted text clipped - 9 lines]
> TIA,
> -=s

Reply to this Message

Scott Willing - 27 Oct 2004 19:12 GMT

N'mind, got it.

"POWER" is the bit I was missing.

-=s

Reply to this Message

JE McGimpsey - 27 Oct 2004 19:14 GMT

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

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

> Howdy,
>
[quoted text clipped - 9 lines]
> TIA,
> -=s

Reply to this Message

Scott Willing - 27 Oct 2004 19:40 GMT

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

>Assuming your "certain cell" is A1, one way:
>
[quoted text clipped - 13 lines]
>> TIA,
>> -=s

Reply to this Message