I am trying to work out how to multiply certain fields on a spreadsheet based on the value of a target cell. For example:
D2= 56 (however this value will change on a daily basis)
Value entered into D23 is 2, however will automatically change to 112.
I need this to happen in numerous...
I have this macro which looks for the unit 'ps' in Column Y and multiplies 1E+12 with the corresponding data in column AC. When it tries to multiply 1E+12, it throws a type mismatch error.
Below is the code.
' Change the value of the data (AC) column - multiply by...
The following is a small sample from a spreadsheet I am constructing. I would like if someone could tell me what formula to put in the cells in Column E so that I can copy it to all cells in Column E and get the right results.
Here are the results I need:
<TABLE style="WIDTH: 315pt...