Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with this:
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help with this:
Normally, assignments are not solved, Lisa.
-- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Lisa" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|