This probably sounds very simple but I'm stumped.
So in the first column I have my mileage rate which is 0.25p per mile then I my full row of values of mileage (300, 180, 120). Then the last cell of the row I want to multiply each value by my 0.25 to give me a total. I've got it to work by manually doing (B1*A1) +(C1*A1) and so on but there must be an easier way. When it gets to 200 cells long it's going to drive me mad. Any help I'd love.
So in the first column I have my mileage rate which is 0.25p per mile then I my full row of values of mileage (300, 180, 120). Then the last cell of the row I want to multiply each value by my 0.25 to give me a total. I've got it to work by manually doing (B1*A1) +(C1*A1) and so on but there must be an easier way. When it gets to 200 cells long it's going to drive me mad. Any help I'd love.
