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

Watch on YouTube

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