Excel - Zero Point Zero Two: Episode 1486
1,581 views · Published 8 December 2011 · 1:47 · Indexed 8 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Save Time and Space in Excel Formulas with this Handy Tip | MrExcel Podcast. Welcome to another episode of the MrExcel Podcast. In this episode, we will be discussing a handy Excel tip that I learned while attending a seminar in Miami. As many of you know, I have done the POWER EXCEL seminar numerous times and have a lot of it memorized. However, during this particular seminar, I was reminded of a simple yet effective way to save time and space in our formulas. During the seminar, I was going through an IF statement formula that looked like this: =IF(AND(A2>20000,B2>0.5),0.02*A2,0). This formula checks if the sales are greater than 20,000 and the GP percent is greater than 0.5. If both conditions are met, then it multiplies the sales by 2%. However, someone in the audience pointed out that I was wasting space by including the leading zero in 0.02. They suggested that I could simply type 2% instead, and to my surprise, it worked! So the formula became =IF(AND(A2>20000,B2>0.5),2%*A2,0). I was amazed by this simple yet effective tip and wanted to share it with all of you. It may seem like a small change, but it can save you time and make your formulas more concise. So next time you need to use a percentage in your formula, remember that you can simply type the number followed by the percentage symbol, instead of adding the leading zero. I hope you find this tip useful and thank you for tuning in to the MrExcel Podcast. Don't forget to subscribe for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Funny Story from Miami Seminar (00:12) Explanation of Formula (00:23) Simplifying the Formula (00:37) Realization and Implementation (01:00) Final Result & Bonus Calculation (01:16) Introduction to AND Function (01:26) Learning Something New (01:37) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: 2% calculation in Excel Episode 1486 Excel tips and tricks Formula with IF and AND functions IF statements in Excel Learn Excel POWER EXCEL seminar Using AND function in Excel Zero Point Zero Two Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153164/ "I was doing a Power Excel Seminar in Miami when I kept typing zero point zero two (0.02) in a formula. Of course, 0.02 is 2%. Someone asked me why I didn't cut the typing in half with 2%. Wow! Silly me... this clearly works!" ...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! *Kindle is Coming to 'The MrExcel Excel Store'! Stay Tuned!* "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920