0

I have so so BIG problem!!

So, I'm trying to generate the verdict syntax calculation, but it shows the wrong answer. Please help me T_T.

The pictures show the filled value from 2 columns before. In the last column, I tried to write the formula: IF([%LIN @150mA]<="10%", "PASS", "NOT PASS") and it didn't work

enter image description here

The data type column of [%LIN @150mA] shows as the picture below. enter image description here

Thank you for your help.

5
  • What is the type of [%LIN @150mA] column? Can you share the screenshot of column settings for this column as well? Oct 17, 2023 at 11:06
  • It's calculated (calculation based on other columns) and the data type returned is number. I have added a screenshot on the top already, thank you.
    – kkaxm
    Oct 18, 2023 at 2:28
  • Try using IF([%LIN @150mA]<=10, "PASS", "NOT PASS") or IF([%LIN @150mA]<=10%, "PASS", "NOT PASS"). Let me know if it works for you. Oct 18, 2023 at 4:22
  • I tried already, but it didn't work again. Can I ask you something? If I calculate from the input number, also use the text function to format like "0.00", and select datatype to number. What is the final type after calculation, is it a number??
    – kkaxm
    Oct 18, 2023 at 4:32
  • Instead of using text() function to format it, use "Show as percentage" check box to % after the calculated number. Oct 18, 2023 at 6:13

1 Answer 1

0

Modified the data type column of [%LIN @150mA] according to the following figure: enter image description here

The data type column of [VD %LIN @150mA] Using this formula: IF([%LIN @150mA]<=10%, "PASS", "NOT PASS")

Numeric percentages do not require double quotes.

Here is my test, ignoring my test data, this worked during my test period: enter image description here


If the answer is helpful, please click "√" on the left panel of the answer and kindly upvote it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.