Excel for PI Day - Using Excel to Calculate Best Pizza Value - Episode 1666

1,122 views · Published 14 March 2013 · 2:28 · Indexed 26 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial:  It's PI Day - 3/14 or 3.14 - and Pizza is typically round in the US, so today Bill has decided to dedicate today's Podcast to =PI()*Radius^2. 

Welcome back to the MrExcel podcast. In this episode, we're celebrating Pizza PI Day! March 14th, also known as 3.14, is a day to honor the mathematical constant PI. But why is this date specifically chosen? Well, let's dive into some Excel magic and find out.

First, we'll format the number 3.14 with a custom number format of M dot D, which represents the modern way of writing the date. And if we use the right number of decimal places, we'll see that it also equals 3.14. A clever math joke that math enthusiasts like myself can appreciate.

But let's not stop there, let's see if we can use PI to solve a real-life problem. In this case, we have Mo's Pizza Shop with two sizes of pizza: a 10-inch for $6.99 and a 15-inch for $10.49. At first glance, it seems like the prices are similar, but let's use our Excel skills to determine which one is the better deal.

We know that the area of a circle is PI times the radius squared, or PI times R squared. So, in Excel, we can use the formula =PI()*(diameter/2)^2 to calculate the area of each pizza. And when we do the math, we see that the 15-inch pizza has a total area of 353 square inches, while the 10-inch pizza only has 235 square inches. Clearly, the 15-inch pizza is the better deal, giving you more pizza for your money. So, next time you're at Mo's Pizza Shop, remember to order two larges instead of three smalls.

So, whether you're a math geek or just someone who loves pizza, I want to wish you a Happy PI Day. And don't forget to treat yourself to a slice of pizza or a blueberry pie, whichever you prefer. Thanks for tuning in to this episode of the MrExcel podcast, and I'll see you next time for more Excel tips and tricks.

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) Explanation of Pi Day 
(00:16) Formatting Pi as a Date 
(00:26) Using Pi to Solve a Real-Life Problem 
(01:01) Comparing Pizza Sizes and Prices 
(01:11) Calculating Area of a Circle in Excel 
(02:03) Choosing the Best Deal at Mo's Pizza Shop 
(02:13) 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:
Area of a circle
Best deal
Custom number format
Episode 1666
Large pizza
Learn Excel
Math joke
Mo's Pizza Shop
Pi Day
Small pizza


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153488/

Follow along with Episode #1666 to get a bit of PI/Pie humor and some Radial number crunching in Excel with MrExcel!

...This blog 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! http://www.mrexcel.com/learn2010/LE2010.html 

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More from this channel