Indian Pay Rounding - 1042 - Learn Excel from MrExcel

Video Description: Another question from Gopal. New India Pay Commission guidelines suggests that pay should be rounded to increments of 10. If the amount over the last 10 is less than or equal to 0.99, then round down. Otherwise round up. While Excel’s built-in functions don’t handle this, Episode 1042 shows you how to handle this using three functions in Excel. This is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new video every workday to learn one of 377 tips from the...

Related Article Subjects: accounting, Business, excel, formula, MrExcel, spreadsheets, technology, tutorial

Play

How to Find the Earliest Date for Records that Match 2 Criteria in Excel

In this Dueling Excel podcast, how to find the earliest date for records that match two criteria. Episode 1104 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from...

Play

WIIW - Classic Pivot Layout - 1058 - Learn Excel Podcast

Michael sends in a great tip today about pivot tables. While Excel 2007 replaced the drag and drop feature with drop zones, there is an obscure setting in Excel 2007 that will let you go...

Play

Axel Font for Excel

Erik Spiekerman has designed a font that is ideal for use in Excel. The Axel font is designed to be narrow yet highly readable both on screen and on paper. In Episode 1054, we will...

Play

How to Choose a Random Name in Excel

Dave wants to know how to choose a random name, but he does not want the complete list of names in the cells in the worksheet! Episode 1020 shows you how. This video is the podcast...

Play

MrExcel's Learn Excel #930 - QAT 2007

It is frustrating that commands in Excel 2007 are spread out amongst 7 different ribbon tabs. Episode 930 will show you how to add your favorite commands to the QAT - Quick Access Toolbar so...

Play

MrExcel's Learn Excel #913 - Pivot Rates II

Yesterday, I talked about Jason's request to format a grouped pivot field in the row area of a pivot table. There is a solution, but it requires a bit of work in the original data...

Play

MrExcel's Learn Excel #923 - Icon Set Alignment

The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it. This video is the podcast companion...