Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How did it caluculate 64 as the answer?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
4 x 4 x 4 = 64
"Sallie" wrote: How did it caluculate 64 as the answer? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"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 |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
Summing Returned Positions using MATCH | Excel Worksheet Functions | |||
Excel Answer Wizard BROKEN | Excel Discussion (Misc queries) | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions |