how would i write the formulas so i can drag it and apply it to other rows?

A) Calculate the value for Regular Hours (Column E). The formula for Regular Hours is based on each employee's Total Hours Worked and is dependent on which department the employee works in. If the Total Hours Worked (column D) is less than or equal to the assigned hours designated by the employee's department (as listed in the table on rows 24 and 25), then just the Total Hours Worked is placed in column E. If the employee worked more than the assigned hours designated by the employee's department, then the regular hours for the department is placed in column E. (See the image above for actual expected values). Write the formula so it can be copied downward to every applicable cell in the column PaySheet o.. Home fx Insert AutoSave ARES- Insert Draw Page Layout Formulas Data Review - - 2.A.0.0- Autosum Recently Financial Logical Text Date & Look & Math & View - More Dette kane Catrace Dependents Remove Arrows Create from Selection recently Finance Show mor Formulas Checking Calculation Options Calculate Function 6 clovee Name Total Hours World Regular Hours Sophou HANDS -251 25) FANDOMarketing D C35109,025) FANDO10 Production",010 1 010 035) -IANO1 ,011-25011835) FLANDB12R",012-625.012.125) FANDI Marketing D C LOU.C753 SAND Sales - 10140251 AND15 .15-11.35) FAN t ion". BOLIG.03 HAND -B35LD25 AND I BOLDI 25 FANDOS . -HLIN, 35) 24 DEPARTMENT 28 Prepared By