multiplies

  1. B

    Shifting formulated cells based on value of a certain cell

    Hello, I need help with the following please. In row 1 I have a row of currency values, A1 thru A1000. In row 2 I need a formula for each cell B1 thru B? that multiplies its corresponding number in row 1 by a factor (B4), but also looks at A3 to tell it how many cells to the right to shift...
  2. M

    VBA to apply formula to existing data in cells

    Cells AT6 to CQ "lastrow" contain numeric values, not formulae I need a bit of code that looks in each cell, divides the value by 7, and multiplies it by the value in row 4 End result should be a value rather than a formula and if the cell was originally blank, it should remain blank Is this...
  3. D

    SUM function

    Hello guys im having trouble doing the following: My goal is to have =SUM(B25*E2, B24*E3, B23*E4, B22*E5, ... means that each time that I drag the column down it multiplies it for an E but oging cells upwards. Any way to easily do this instead of manually doing everything? Thanks guys!
  4. M

    multiply a entire column, by another column

    I want to multiply an entire column, by another column, and accumulate the results. Like this: <tbody> A b c 2 5 10 3 4 12 4 3 12 5 2 10 </tbody> and then sum them. the result would be the sum of all the column c = 44. how can I do it? how can I calculate c directly? do you know a...

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
Back
Top