apply equation to ranges

  1. I

    Have cell allow a "Range" or multiple cells to be referenced

    Hope this makes sense. :confused: Trying to get a problem solved to have a % discount & 'flat' $ discount apply to cell(s) referenced. Product A, B & C are available in 3 different materials. Objective is to allow each material's Max Discount column to apply discount(s) referenced in cell J3 &...
  2. E

    How to copy formulas in 20000 rows in excel without having to drag down the corner of the box?

    Hi everyone, I'm trying to apply a formula to more than 20000 rows of excel on a mac. It takes too long to drag down the corner of the box so I was wondering if you know of any other ways. I know that you can double click on the corner of the first box but you can only do that for all the rows...
  3. C

    Optimizing loop: apply equations to ranges without using loop

    Hello Experts, I'm am trying to optimize my vba codes and am running into a road block; I'm pretty sure there is a solution out there but I haven't been able to find it for days. I am trying to apply an equation to a ranges of cells without using a loop. I have been successful at using the...

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