L
Lisa
In cell M4, put the label "Allowance." In cell M5, type "0.32" (the amount
paid per mile). In cell M8, put a formula that multiplies the mileage in cell
L8 by the mileage allowance in cell M5. (Remember to use an absolute
reference to cell M5 and a relative reference to L8.) Copy the formula to
cells M9:M11.
In cell N8, sum the range C8:K8 and M8 (omitting column L, which is not an
expense). Hint: One way is to use the SUM function for the contiguous range
and add in the noncontiguous cell. Another way is to enter the range as two
separate arguments of the SUM function.) Copy the formula to cells N9:N11.
Select the column headings in row 6 and format them as bold.
paid per mile). In cell M8, put a formula that multiplies the mileage in cell
L8 by the mileage allowance in cell M5. (Remember to use an absolute
reference to cell M5 and a relative reference to L8.) Copy the formula to
cells M9:M11.
In cell N8, sum the range C8:K8 and M8 (omitting column L, which is not an
expense). Hint: One way is to use the SUM function for the contiguous range
and add in the noncontiguous cell. Another way is to enter the range as two
separate arguments of the SUM function.) Copy the formula to cells N9:N11.
Select the column headings in row 6 and format them as bold.