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. ...