Microsoft Excel Tips: -2^2 = +4 and NOT -4!!!
242 views · Published 17 December 2012 · 4:08 · Indexed 12 November 2026
Channel: Math Easy Solutions · 2012 · Education
In this video I go over a very useful tip in Microsoft Excel 2007 (it should be the same for all other versions of Excel). Basically typing in a calculation like -2^2 is calculated as (-2)^2 = +4 in Excel. Every other calculator I have ever used calculates it as -(2^2) = -4. It took me over an hour to see why my school assignment was giving the wrong answer in Excel and figured out that one of my calculations involved the calculation -x^2, which I thought it would return a negative number but Excel gave a positive. Make sure you watch this video because it could save you a lot of time if this ever happens to you!! Download the notes in my video: PDF: https://1drv.ms/b/s!As32ynv0LoaIiOlCk3fCF24DDww9ig?e=PTyXub Excel: https://1drv.ms/x/s!As32ynv0LoaIiOk8ew8fEvwCUutczw?e=kXbjQB View video notes on the Hive blockchain: https://peakd.com/hive-128780/@mes/microsoft-excel-tips-22-4-and-not-4 Related Videos: Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007: http://youtu.be/fwMKbXI98tI Converting Numbers to Fractions in Microsoft Excel 2007: http://youtu.be/YgJBK0QjIec Intro to Tables in Excel 2007: http://youtu.be/B_zXmunqrl4 Drop Down Lists with Microsoft Excel 2007: http://youtu.be/e7Sbcn-y9j4 Proving Pi = 3.14... with Microsoft Excel - A Visual Proof: http://youtu.be/gfAAh75dsLw . ------------------------------------------------------ Become a MES Super Fan! https://www.youtube.com/channel/UCUUBq1GPBvvGNz7dpgO14Ow/join DONATE! ʕ •ᴥ•ʔ https://mes.fm/donate SUBSCRIBE via EMAIL: https://mes.fm/subscribe MES Links: https://mes.fm/links MES Truth: https://mes.fm/truth Official Website: https://MES.fm Hive: https://peakd.com/@mes Email me: [email protected] Free Calculators: https://mes.fm/calculators BMI Calculator: https://bmicalculator.mes.fm Grade Calculator: https://gradecalculator.mes.fm Mortgage Calculator: https://mortgagecalculator.mes.fm Percentage Calculator: https://percentagecalculator.mes.fm Free Online Tools: https://mes.fm/tools iPhone and Android Apps: https://mes.fm/mobile-apps
More from this channel
-
4:11
Graphing with the Google Search Part 1
-
5:31
Graphing with the Google Search Part 2: Multiple Curves and Wolfram Alpha Comparison
-
6:55
Equation of a Line - A Simple Explanation
-
9:17
Calculate what you need on the final to pass the course! Finalexamcalculator.com
-
12:40
Power Functions Part 3: Graphing
-
12:34
Trigonometry: Sine, Cosine and Tan Functions
-
3:43
Troll Physics: 1 = 0??!!! Division by Zero Fallacy
-
10:48
Exponential Functions and Graphing