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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top