Most valuable professional
  • Hot Topics

Excel Adding to the formulas of many cells at once

Hi, I have a long list of rates (hourly wages) in my spreadsheet. These are hardcopy numbers (values), not formulas. I would like to add an escalation to the rates by referencing a cell where I can enter an escalation factor. For example: In cell A1 I write an escalation value. For example 102%. So if I multiply the hourly rate of 345 by this factor, the rate is increased by 2%. A1: 102% Colomn B: 345 786 554 325 986 ... Instead, I would like the contents of colomn B to read like this: Colomn B: =345*$A$1 =786*$A$1 =554*$A$1 =325*$A$1 =986*$A$1 So, I would like a way to add *$A$1 to all cells in Colomn B without manually typing it in each cell. Is there a way to do that without using Macros/VBA? Yes, I know I can just use Colomn C and write in cell C2=B2*$A$1 and I would have the values I want in that colomn. This does not fit with the format of my spreadsheet which is used in my company, and is not an option. Yes, I could also just temporarily get the values from colomn C as discussed above and copy-paste values into colomn B and then delete colomn C again. Again, that is not what I want to do. I want colomn B do be dynamic and have references to A1 (escalation factor). Thank you so much for your help in advance There are always a lot of smart Excel users on this forum.

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of August 15, 2016.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel