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 .
SUBSCRIBE via EMAIL: https://mes.fm/subscribe
DONATE! ʕ •ᴥ•ʔ https://mes.fm/donate
Like, Subscribe, Favorite, and Comment Below!
Follow us on:
MES Truth: https://mes.fm/truth
Official Website: https://MES.fm
Hive: https://peakd.com/@mes
MORE Links: https://linktr.ee/matheasy
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
▶️ DTube
▶️ IPFS
I don't always calculate -2^2 in Microsoft Excel but when I do I usually get the wrong answer ;)
View video notes on the Hive blockchain: https://peakd.com/hive-128780/@mes/microsoft-excel-tips-22-4-and-not-4
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I thought that You left Steemit but I see You still sometimes publish here. But rewards are dead.
I dont know why Steem and SBD keep high value on exchange.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit