General discussion
March 22, 2006 at 05:21 AM
aqusenu

Excel formula multiply by single cell

by aqusenu . Updated 20 years, 6 months ago

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

This discussion is locked

All Comments