SOLVED

# Help with IF/OR Statement

Copper Contributor

# Help with IF/OR Statement

Hello,

I am looking for some help with an IF statement. I want column H to display Y if F>=G, but display N if A is True (displays as True when the box in B is checked). I am getting the correct results in H based off F and G with an IF statement: IF((F>=G),”Y”,”N”). However, when I try to create an OR statement to add in the other argument I am not getting anywhere.

 A B C D E F G H Linked Cell Lump Sum(Check if Yes) Salary Recommendation Salary Before Increase Salary After Increase 2024 Compa Ratio Max Compa Ratio TRUE ☒ \$107,377.00 123% 120% N

Thanks!

Natalie

2 Replies
best response confirmed by Natalie_Asher (Copper Contributor)
Solution

# Re: Help with IF/OR Statement

=IF(OR(A2, F2<G2), "N", "Y")

# Re: Help with IF/OR Statement

@HansVogelaar Thank you very much. So helpful!

1 best response

Accepted Solutions
best response confirmed by Natalie_Asher (Copper Contributor)
Solution

# Re: Help with IF/OR Statement

=IF(OR(A2, F2<G2), "N", "Y")