LinkBack URL
About LinkBacks
3+2^1=5
3+2^0=3
3+2^2=11
why did equation 2 and 3 have different numbers than the original which is 5 cuz 3+2=5 not 3 or 11
How to use the exponent symbol in formulae in Excel
3+2^1=5
3+2^0=3
3+2^2=11
why did equation 2 and 3 have different numbers than the original which is 5 cuz 3+2=5 not 3 or 11
Last edited by AliGW; 01-08-2017 at 12:42 PM. Reason: Poor thread title amended.
Your question should have been about how exponents change values. I recommend that you change it.
The answer lies in how the exponent (the part with ^and number.
2^1=2
2^0=1
2^2=4
Result
3+2^1=5
3+2^0=4
3+2^2=7
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hello Clesau & Welcome to the Forum,
Administrative Note:
- We would love to continue to help you with your query, but first, before we can proceed…
- Please see Forum Rule #1 about proper thread titles and adjust accordingly...
HTH
Regards, Jeff
Thank you :D didnt realize admins answer us
Please go back again and change your thread title as suggested by Newdoverman in post #2 of this thread. "I need help with this equation" is no use: it's too vague. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
.-. what do you mean am I not allowed to type as the title of some one ._. seriously
I have no idea what you mean. You have been asked to change your thread title: as a one-off, I will do it for you, but in future you must follow the forum rules and use titles that are more explicit of the problem you are facing.Originally Posted by Clesau
Just to clear this up for you, Clesau, you need to give your thread a title that is descriptive of your problem - not what you think the answer might be. (think google search terms?).
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
Thanks for your understanding
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
what i mean is that why cant i put this title it is ok
because it in no way describes what your problem is. Look at it this way, is that the terms you would use, to find help in google?
(I just got 81 700 000 hits using your title in a google search)
Plus, some members will only respond to certain types of threads.
Hope that explains it for you
1. In adjacent blank cell C1, enter this formula: =Power (A1, 3),
2. Then tap Enter key, and select cell C1, then drag the fill handle over to C10
Use the symbol ^ to apply the exponential calculations. Such as 10^2, it stands for 10 to the power of 2. And the calculating result is 100. So we can use this way as follows:
1. In adjacent blank cell C1, enter this formula: = A1^3.
The reason that you are getting unexpected results is in not understanding what the ^ does.
Enter the following in Excel
=2^0
=2^1
=2^2
The answers will be in order
1
2
4
Data Range
Your formula results
3+2^1=5
3+2^0=4
3+2^2=7
Last edited by newdoverman; 01-10-2017 at 06:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks