I'm using IF + MOD function to return 1 or 0, it is supposed to be 21 cells with 1 followed by 7 cells with 0 but the result is not as expected. A1 has 21 then A2 has 7 to simulate the 21/7 days rotation. I put this formula =IF(MOD(ROW(A21),$A$1+$A$2)>=$A$2,1,0) to B1 and dragged down, the result is 7 consecutive cells of 1 followed by 7 cells with 0, 21 with 1 then 7 with 0. The rest are constant cycle of 21 and 7. What am I missing on this formula and what are the limitations if I need to use this on rows rather than columns or in multiple rows/ columns?
21 days ON & 7 days OFF rotation through out the year using MOD function
44 views Asked by markkeith At
1
There are 1 answers
Related Questions in FUNCTION
- Dynamic array of structures in C++/ cannot fill a dynamic array of doubles in structure from dynamic array of structures
- Function is returning undefined but should be returning a matched object from array in JavaScript
- How do you import functions from one page to another in Jetpack Compose?
- Adding Modules to a Namespace using IIFE
- How to convert mathematical expression to lambda function in C++?
- Custom Bash functions & custom statements - Need some advice
- Why my code is working on everything except one instance?
- Getting a function to call an equation
- Create Symbolic Function from Double Vector MATLAB
- Recursive calls to function passed as a parameter of another method via Consumer interface
- How can I replace a word in SQL but only if it is the last word in the string for a scalar-valued function?
- iterating through raster bands to perform calculation
- How to make this sensor keep taking readings once its when_in_range function has been activated?
- TypeError: indice_delete() takes 0 positional arguments but 3 were given
- How to modify HTML in WordPress core file
Related Questions in EXCEL-FORMULA
- How would I apply a rather complex summation formula like this in Excel?
- Excel - Update Item Description Based on Accessories Ordered with It
- select duplicates from data based on another column
- Look up max alpha numeric value
- Assistance with sum for multiple separate rows using multiple criteria please
- Excel Index+ match Returns duplicate value
- requesting excel formula to compare columns but going in order and skipping blanks
- Concatenate and dropping leading zeros
- Math's & Excel formula to calculate the interest rate from the EMI and principal amount?
- Excel - How get everything to the left of the second to last instance of a character
- Calendar is not Highlighting Accurate Time
- How to search for size in the list and set costing based on it?
- Is there a way to set a cells value based on the value this cell held at a certain time, even when the cell value changes over time?
- How to sum monthly data in Excel into quarterly
- Can I use Sumproduct arrays and check two separate criteria counting TRUE statements?
Related Questions in ROSTERING
- Adjustments to Shift Rostering in pyworkforce/OR Tools - Non sequential Shifts
- Optaplanner ConstraintStream doesn't work
- Nurse rostering - Assigned shifts cost
- Algorithm to create a volunteer roster based on each person's availability
- 21 days ON & 7 days OFF rotation through out the year using MOD function
- Quota script for a roster
- Automatic rostering in Google Sheets
- Is it an overconstrained rostering problem not addressed properly?
- Run optaplanner at AWS Lambda is good enough?
- Personnel Scheduling Benchmark Instances
- How do I add constraint to pyomo with a range inequality
- Minizinc Roster constraints
- Minizinc. Count number of shifts in a cycle
- Display row number without moving column
- Editing rules for employee rostering example
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
You could modify your formula like that:
then it print correctly a series of 21 times 1 and 7 times 0 in loop