Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 13, 2023 04:45 AM
Hi,
I am trying to create a simple IF Statement to produce the result PASS or FAIL if the value in another column is >= 80%: In Column 1 ('% germination rate on second check') are % figures with values ranging from 0% to 100%. The purpose of the Column 2 ('PASS/FAIL'), is to produce the word 'PASS' if the value of Column 1 is >= 80%, or 'FAIL' if otherwise. Currently all cells in Column 2 are showing 'FAIL', irrespective of the % figure showing in Column 1. Is this some kind of syntax or formatting error on my end?
Here is my formula: IF({% germination rate on second check} >= 80, "PASS", "FAIL")
Thanks for the help! 🙂
Solved! Go to Solution.
Sep 13, 2023 04:32 PM
80% is only an apparent number formatted as the amount per hundred.
Internally, it has a value of 0.8.
IF({% germination rate on second check} >= 0.8, "PASS", "FAIL")
Multiplying the "percent" by 100 is also a good idea.
Sep 13, 2023 05:04 AM
Percentage field, right?
Then 100% is 1 and 80% is 0.8.
8000% would be a PASS!
Sep 13, 2023 06:00 AM
Hi @Sho ,
Thanks for you reply. I am a beginner here and I don't follow what you're saying. Would you be able to explain? Or offer an alternative formula that may work if your logic is correct?
Thanks so much for the support!
Z
Sep 13, 2023 07:02 AM
I think I've figured it out by changing my formula to:
Sep 13, 2023 04:32 PM
80% is only an apparent number formatted as the amount per hundred.
Internally, it has a value of 0.8.
IF({% germination rate on second check} >= 0.8, "PASS", "FAIL")
Multiplying the "percent" by 100 is also a good idea.
Sep 20, 2023 03:29 AM
Ok - I understand. Cool - thanks for your help @Sho!