April 2, 2011 – GUNNALAG

April 2, 2011August 12, 2014Desktop

Excel Formulas

Data Validations: Checking whether the cell has a number or not, usually useful while checking accounts/transactions/banking sheets. =(F2-(IF(ISNUMBER(D3),D3,0))) + (IF(ISNUMBER(E3),E3,0)) Checking whether the cell is BLANK, usually useful in textual/string validations =(F2-(IF(ISBLANK(D3),D3,0))) + (IF(ISBLANK(E3),E3,0)) Conversions: Date values: India to US Input Date Format: 7/1/2011 (days in single digits) Conversion Formula: DATE(YEAR(B3),DAY(B3),MONTH(B3)) Output Date Format: 1/7/2011 Input Date Format: 14/01/2011 (days in two digits) Conversion Formula: DATEVALUE(MID(B8,4,2)&”/”&LEFT(B8,2)&”/”&RIGHT(B8,3)) Output Date Format: 1/14/2011 Reference articles: How to use dates and times in Excel HOW TO: Convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000

April 2, 2011Financial

Indian Banks Salary Accounts Interest Calculator

With effect of below RBI directive as describe by CRISIL RBI has proposed that all scheduled commercial banks start the computation of monthly interest on savings accounts on a daily basis with effect from April 1, 2010, instead of the current method of linking the interest to the minimum balance between the tenth and last day of each month. thus now banks pay interest rate (currently it’s %3.5 p.a) on a daily basis. This simply means that interest is calculated for every unique balance in your account for the number of days you hold it. However, banks still pay this […]