Hello, I am currently trying to figure out something for my Job. We measure the number of particles, and if the number of particles are in a certain threshold of values, we assign it a number (code). So the program I am trying to write is the following:
-See the attachment
-Assign a value (called "code"(column N) in the attached file) to "Code 1"(column B) if "part 1"(column J) is within bottom(column O) and top(column R).
-Then, based on the code, I want it to write out "LOW", "MID" or "HIGH" for "Thres 1"(column F) based on where "PART 1"(column J) is within that threshold. LOW being between the Bottom threshold value and 33%, MID being between 33% and 66% and HIGH being between 66% and the top threshold.
Any help is greatly appreciated.
Thanks!
Bookmarks