the number to the power

[abbccc]

how to show 2*2*2 in 2³

[Fotis1991]

=power(2,3) ?????

[Kevin UK]

Hi abbccc

Try the following for your example: 2^3

[Pepe Le Mokko]

Hi abbccc

Try the following for your example: 2^3

Same as #2

[Kevin UK]

@ Pepe Le Mokko

AND!!

OH lets use: =SQRT(POWER(2,2)+POWER(3,2))

I think I prefer:=SQRT(2^2+3^2)

[ChemistB]

I like
= 10^(3* LOG(2))


EDIT:
=EXP(3*LN(2))
then you don't have that pesky caret to worry about.

[shg]

How about =IMABS("2+3i")

[Pete_UK]

I think the OP is asking how you could show that as:

2³

within the cell, not how you would calculate it using functions.

We'll have to wait for the OP to come back to us.

Pete

[ChemistB]

How about =IMABS("2+3i")

Nice try but I get 3.60555. Wish it did work though.

Could use 2³=EXP(IMABS("2+2.236068i")*LN(2))
But that's cheating, don't you think?

[shg]

I was looking at =SQRT(2^2+3^2) from post#5

[abbccc]

i want display power a list in column a to column b
for example
display power.jpg

[dilipandey]

Hi abbccc,

Select the number which you want to display as power and format as "superscript".

Regards,
DILIPandey
<click on below * if this helps>

[ChemistB]

I was looking at =SQRT(2^2+3^2) from post#5

Oh, well, that's okay then.

[aydeegee]

Could use 23=EXP(IMABS("2+2.236068i")*LN(2))
But that's cheating

... and only accurate to 6 decimal places

Alastair
(President elect of Cat Skinning Incorporated)

[ChemistB]

I'm a 3 or 4 significant figure kinda guy. Take Pi for example,

If the circumference of the earth were calculated using π rounded to only the ninth decimal place, an error of no more than one quarter of an inch in 25,000 miles would result.

Thirty-nine decimal places of pi suffice for computing the circumference of a circle girding the known universe with an error no greater than the radius of a hydrogen atom.

and yet, we insist on taking it out to over a trillion digits.