k15

  1. R

    Offset to merged cell doesn't work

    Hi, On my sheet columns K:M are merged cells (only horizontally merged) The same applies to columns N:P I'm trying to give a variable column offset to cells/ranges in column K with Integer Ccol1 In this example, Ccol1 = 3 So K15 as starting point should result in N15 where I want to set a...
  2. S

    Using SUMIFS to multply a cell

    I am trying to write a formula that will multiply the value in cell I15 by 5 if that cell is at 20 or more, and if cell I16 is equal to or higher than 105.95 and display the result in cell K15 In other words, I input 19 or less into cell I15, K15 shows 0 I input 20 into cell I15 and if cell...
  3. B

    Trigger Macro when Cell>Another Cell

    Hiya all, I am trying to trigger a macro as soon as a cell in a range becomes greater than a corresponding cell within another range, eg below Range k:K is the "original" range, this is what the cells within AU:AU are comparing to, As soon as a cell in range AU:AU is >= the same cell in K:K...

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