SOLVED

Help with IF/OR Statement

Copper Contributor

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

@Natalie_Asher 

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

@HansVogelaar Thank you very much. So helpful!

1 best response

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

@Natalie_Asher 

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

View solution in original post