reaches

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

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

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

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

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

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

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

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

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

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