j15

  1. Q

    Nested IF?

    I have a series of prices as; D4 = Item A, D5 = Item B D6 = Item C I have a IF statement in J15 which reads =IF(H15="YES",$D$4+D$6$,0) so adding Item A + Item C In I15, if this contains a "Yes", I want the above statement in J15 to add together all three items (so D4+D5+D6) What is the best...
  2. J

    I need help with automatic last updated cell

    Hey! I had this VBA code working until i put a formula in in J15 in the "Data" workbook. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("J15")) Is Nothing Then Exit Sub Range("K18") = Now() End Sub My plan is to paste the data from A1 in "hej.xlsm" to...
  3. M

    copy a cell reference down starting at row x and then every nth row

    Hi All, I'm trying to tidy up some data into another tab. The source data is infinitely lings I wanted to create a formula to tidy the data into a new sheet.. The data starts on row 5 every time and thenext set of data is every 10 rows thereafter. I’m guessing I need to use the offset, but...

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