reaches

  1. W

    Please someone help me!

    Good morning everyone, I hope this is the place I can get some help with this....ill try to keep this problem short: I have a spreadsheet for absence. Our corporate trigger levels where an employee progresses to a stage of absence are 6 days in a row,4 weeks in a row, 3 months in a row and or...
  2. N

    Counting # of times a stock reaches a certain price in a session/Probabilities

    How can I record # of times a stock reaches a certain number throughout the day? Currently I only have a function for when it is at that number it returns 1 and if not a 0. i need a running count. Basically I am looking to record the success of a tick fade play. When the $TICK reaches +1000...
  3. C

    Running and stopping a macro based on a cell value

    Hi. I'm using =rand( for the data and setting it to 3 decimal place. As you know anytime you click, input, etc. in any cell, the =rand( automatically changes. I want a macro, where I can continuously have it input something (i.e. in column D it just keep inputting "1 Enter") so it keeps...
  4. B

    Adding value in a cell

    Hi I kindly need an IF formula that when adding 100 to the cell it increases, example when I put value in B2 cell then B3 gets increased until reaching 100. Then in B4 a message tells “reaching the range”. The message will not show until B3 reaches 100 and so. When B3 reaches 100, it still gets...
  5. B

    Excel formula to add with conditions

    Please tell me an excel formula to add in following manner: If a1 = 1640, a2 = a1+65, a3=a2+65, a4=a3+65, a5=a4+65, a6=a5+65 until it reaches 2095 then a7=a6+80.........until it reaches 3135 then next cell=the previous result+100...................until it reaches 3635
  6. B

    Automatic addition from a range

    I have a range such as: 1780-25-1900-45-2050-65-2550-80.... Now I want an Excel formula so that addition from the range will be: 1780+0 in one cell, 1780+25 in next cell, 1780+25+25 in next cell, 1780+25+25+25 in next cell,..... until it reaches 1900, then 1900+0, 1900+45, 1900+45+45, until it...
  7. C

    Incrementing last digit in a custom serial number

    Hi, i am trying to increment the last digit of a custom field. An example is 2018-08-001. The code i am using is left(a1,10) & 1 + right(a1,1) I am having issues when it reaches 2018-08-009. It becomes 0010. Also probable future problem is whenb it reaches 2018-08-999. Any help is appreciated...
  8. H

    Subtract from one cell until it reaches "0" before moving on to another cell

    <tbody> I J K L M 1 100 200 0 175 125 2 0 125 0 175 125 </tbody> ROW ONE: When entering a value in L1, I would like the amount to deduct from I1 until it reaches zero before deducting from J1. M1 is the balance for the row ROW TWO: Is how it should look if the formula is correct.
  9. M

    Simple way to increment by 10% until a value is reached?

    Hi all, I am working on resizing an image in Photoshop rather drastically, and one of the tips to to go in 10% increments until I reach my goal, and since I am looking at roughly 100 steps, I was thinking that I could calculate my numbers in Excel. I'm just not sure how to do that. I am starting...
  10. S

    Insert values from one column depending on value in another column

    I have a list of values in columns A and B. There is a list of 'trigger' values in C, dictating whether A values or B values go in D. The rules are: 1 Insert in column D a value from A when value in C reaches 4 2 Continue to insert in column D value from A until value in C reaches 5 3 Then...

Watch MrExcel Video

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