nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

44800_en-US

liliconcom

Setting up pass/fail codes based on values in another column

I have a hard time with conditional formatting. In the attached file, for example, I would like to assign pass/fail codes, 0 or 1, in column 2 depending on the value in column 1.

How would I set up the formula for, If Column 1 > 0.5, then Column 2 = 1, If column 1 <0.5, then column 2 = 0?

Re: Setting up pass/fail codes based on values in another column

Thank you. I'm rockin' and rollin' now!

Re: Setting up pass/fail codes based on values in another column

Here is the formula:

If(
 :Column 1 > 0.5, 1,
 :Column 1 < 0.5, 0
)

I would suggest that one of the 2 comparisons be changed to >= or <=, since what you specified would leave a value of exactly .5 as a missing value for the Failure column

Comments

There are no comments yet