multiply by constant

  1. J

    Entered Cell value to multiply based on target cell value.

    Hi, 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...
  2. P

    VBA - Error 13 - Type mismatch

    Hi, 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. Sub Multiply_Tdata() ' ' Change the value of the data (AC) column - multiply by...
  3. S

    Formula Help Needed ASAP!

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top