In cell J8, calculate the cost allowance per mile under the Mileage $ column for each date. You need to multiply the mileage by the mileage allowance….

In cell J8, calculate the cost allowance per mile under the Mileage $ column for each date. You need to multiply the mileage by the mileage allowance. Be sure to use an absolute reference when referring to the mileage allowance because it is not in the table and only occurs once at the top of the sheet.