ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do you get # value returned by entering: =4^3 (answer 64)??? (https://www.excelbanter.com/excel-discussion-misc-queries/86819-how-do-you-get-value-returned-entering-%3D4%5E3-answer-64-a.html)

Sallie

how do you get # value returned by entering: =4^3 (answer 64)???
 
How did it caluculate 64 as the answer?

Marvin P. Winterbottom

how do you get # value returned by entering: =4^3 (answer 64)???
 
4 x 4 x 4 = 64

"Sallie" wrote:

How did it caluculate 64 as the answer?


Abode

how do you get # value returned by entering: =4^3 (answer 64)???
 
That is correct sir. Four carrot three is just four times four times four.
Sixty-four is the answer. What calculation did you want to do?

"Sallie" wrote:

How did it caluculate 64 as the answer?


Sallie

how do you get # value returned by entering: =4^3 (answer 64)
 
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?


Abode

how do you get # value returned by entering: =4^3 (answer 64)
 
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?


Sallie

how do you get # value returned by entering: =4^3 (answer 64)
 
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?


Dave Peterson

how do you get # value returned by entering: =4^3 (answer 64)
 
um, 81.

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?


--

Dave Peterson

Abode

how do you get # value returned by entering: =4^3 (answer 64)
 
Ah.. Hahaha. I hit the wrong number by mistake.

"Dave Peterson" wrote:

um, 81.

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?


--

Dave Peterson


Abode

how do you get # value returned by entering: =4^3 (answer 64)
 
I'm sorry but its difficult to understand your english. I think you have the
idea. If you know that 3^4 is the same as 3x3x3x3 then you understand it
perfertly.

"Sallie" wrote:

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?


RagDyeR

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?




David Biddulph

how do you get # value returned by entering: =4^3 (answer 64)
 
"Abode" wrote in message
...
3x3 x3x3= 9x3 x3= 27x3 = 91


Are you *sure*? :-)

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


caret
--
David Biddulph




All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com