Develop the commands to calculate the group insurance premium (Gl) and Tax Deducted at source (TDS) by using the ‘IF’ function.
1. Rate of GI Rs. 200/- for BP below Rs: 8000/- and for others Rs. 300/-, assuming that BP of employee is given in B2.
2. TDS 10% of Gross pay, for employees having Gross pay below Rs. 15,000/- and for others, 20%, assuming that the gross pay of the employee is given in F2.