Method 1 – HRA Calculation on the Basic Salary in Excel Enterthe amount of basic salary and HRA forMayinC5andC6. InD5use this formula tomultiplyC5by12to calculate the annual basic salary. =C5*12 Using the same formula, multiplyC6by12or drag the Fill HandletoD6to copy the formula. ...
HRA Exemption - Formula to Calculate with Example The HRA calculation example will help you fully understand the HRA calculation formula. Neha Sharma works for a multinational corporation in Mumbai. The rent for her apartment is ₹10,000 per month. The monthly salary structure for her is as ...