Help me to fixing the formula.
Hi there,
I'm getting wrong output in result column, please check and help me to understand the formula for 'Repeat Reactions'.
please check the below explanation.
I want check the how many no of Repeated Reactions for each Target code and each Step number.
Target Code Column has unique set of ID's:
Step # Column has Step ID's(Step 1, Step 2, Step 3...)
Batch size column has quantity(50,5,20...)
Logic:
If Batch size is less than 25mg, No Action required.
If Batch Size is more than 25mg, then count the number of reactions for Each step.
If No of Reactions Per Step is less than 2 times, No Action required
If No of Reactions Per Step is greater than 2 times, consider it as "Repeated Reaction".
Thanks
Shaik
Answers

It looks like it is working to me. Exactly what is wrong with it?
Help Article Resources
Categories
Check out the Formula Handbook template!