Income Tax Calculation formulas in Excel

Friends, How to calculate income tax in excel. No doubt there are lot of tax calculator available in market. But there is no detail how they have calculated the same. Many time we feel requirement of income tax calculation in excel. The said formula calculates Income Tax of man, women, senior citizen and very senior citizen for assessment year 2013-14. Picture view with detailed formula's is given below :-

The above calculations are simple and can be used through copy and paste etc. The above sheet is available in two part i.e. one is shown in green colour for used of user and second is shown in white colour which is only for calculation not for end use. Date of above picture is also given below for easy reading otherwise picture can be enlarged to view to formula's