Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sallie
 
Posts: n/a
Default how do you get # value returned by entering: =4^3 (answer 64)???

How did it caluculate 64 as the answer?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom
 
Posts: n/a
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Sallie
 
Posts: n/a
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
Abode
 
Posts: n/a
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.misc
Sallie
 
Posts: n/a
Default 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?



  #6   Report Post  
Posted to microsoft.public.excel.misc
Abode
 
Posts: n/a
Default 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?

  #7   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?



  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #9   Report Post  
Posted to microsoft.public.excel.misc
Abode
 
Posts: n/a
Default 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

  #10   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default 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




  #11   Report Post  
Posted to microsoft.public.excel.misc
Abode
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i cant get the exact answer e.g answer is 13.49% i got 13.00% zai Excel Discussion (Misc queries) 3 June 9th 05 01:00 PM
Summing Returned Positions using MATCH Sam via OfficeKB.com Excel Worksheet Functions 10 April 16th 05 11:30 PM
Excel Answer Wizard BROKEN Mark Diaz Excel Discussion (Misc queries) 1 March 11th 05 10:19 PM
Display answer only in another cell of one containing a formula Mally Excel Discussion (Misc queries) 5 January 21st 05 01:07 PM
coverting answer from Radian mode to degree mode Xmastrzman Excel Worksheet Functions 1 November 10th 04 04:45 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"