Indian Pay Rounding - 1042 - Learn Excel from MrExcel

Tags:: Excel Business Accounting Spreadsheets Tutorials Technology MrExcel Formula

Edit Video Details

Share
Add to Favorites
Report
Download

By: MrExcel
Subscribers: 10
Updated: 25-Nov-09
Videos: 223

International
Comments: 0
Views: 270
Added: 23-Jun-09

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 book!