Adnan Halai
New Member
Hello Experts,
I am working on plant manufacturing sheet where in I am working to calculate formula for below logic.
If any of the first 8 "Batches" on each day is the value of 100 then the "Cycle" column should be marked at that point with a 1. Otherwise if none of the first 8 results on each day have a "Batches" with the value of 100 then the 8th result should be marked with a 0. All the rest should be blank.
Attached is the spreadsheet for reference.
I am working on plant manufacturing sheet where in I am working to calculate formula for below logic.
If any of the first 8 "Batches" on each day is the value of 100 then the "Cycle" column should be marked at that point with a 1. Otherwise if none of the first 8 results on each day have a "Batches" with the value of 100 then the 8th result should be marked with a 0. All the rest should be blank.
Attached is the spreadsheet for reference.
Attachments
Last edited by a moderator: