Forum Discussion
Natalie_Asher
Feb 15, 2024Copper 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
=IF(OR(A2, F2<G2), "N", "Y")
=IF(OR(A2, F2<G2), "N", "Y")
- Natalie_AsherCopper Contributor
HansVogelaar Thank you very much. So helpful!