Forum Discussion
Multiplying a column by a constant problem
Hi there, I am trying to inflate a series of numbers by 3% in excel. I am doing this by multiplying by 1.03 I applied this formula to the first cell in a column and have done the calculat...
Do it like this:
- Enter 1.03 in an empty cell.
- Select that cell and copy it.
- Select the target range.
- Right-click in the selection and select Paste Special... from the context menu.
- Alternatively, click the lower half of the Paste button on the Home tab of the ribbon and select Paste Special... from the dropdown menu.
- Click Special.
- Select Multiply.
- Click OK.
- Clear the cell in which you entered 1.03.
HansVogelaar that worked, thank you very much!!