View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR
 
Posts: n/a
Default how do you get # value returned by entering: =4^3 (answer 64)

It's called raising a number to a certain power.

2^2 is the way *XL* displays and calculates "Two squared".
It's normally displayed in text as " 2² ".

2^3 is "Two cubed", with a text display of " 2³ ".

For you, a general rule could be the first number multiplied by itself as
many times as the second number.
2^2 = 2 X 2 = 4
2^3 = 2 X 2 X 2 = 8
2^4 = 2 X 2 X 2 X 2 = 16
2^5 = 2 X 2 X 2 X 2 X 2 = 32
.... etc.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Sallie" wrote in message
...
Thank you Abode very much! Your finding out I'm not a math major!

So as thick-headed as I am, in my words it should mean? anytime a number
before ^ for example: 3^4 : just muliply the times of second number for
first number before the ^ with the second number, whatever that number is.
3^
(should be multiplied by 4 (the second number) that is it is always
multiplied with the amount of that second # ??

"Abode" wrote:

3x3 x3x3= 9x3 x3= 27x3 = 91

All the ^ does is say the number preceding is multiplied by itself the
number of times after the ^ (carrot is its name I beleive).

So 2^32 would be
2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x2x 2x2x2x2x2x2x2 which

equals
4,294,967,296

"Sallie" wrote:

Thank you Marvin very much.

Now how about if calculation was =3^4 ( answer___) ???




"Marvin P. Winterbottom" wrote:

4 x 4 x 4 = 64

"Sallie" wrote:

How did it caluculate 64 as the answer?