I have a long list of values to apply a multiplier to. Rather than copy the value down the entire column, so it exists in each row, I thought there was a way to select the row value and multiply it by the common multiplier. I thought it might be a function but cannot find a function that works for this. I am using Excel 2000
Example
Multiplier = 1.17
Values Desired Result
1 1 x 1.17
5 5 x 1.17
10 10 x 1.17