Forum

Notifications
Clear all

2 AND statements with an OR statement?

2 Posts
2 Users
0 Reactions
60 Views
(@gavin80)
Posts: 1
New Member
Topic starter
 

Hey how can I use 2 AND statements with an OR statement?

=IF(AND(G2>=2016,K2<=2019),IF(AND(G2=2017,K2<=2019),IF(D2<25000,"-",IF(D2<25000,"$200.00",IF(D2<40000,"$225.00",IF(D2=45000,D2*0.0065)))))))

So if G2 less than 78 AND is between 2016 - 2019 - OR - if G2 less than 84 AND is between 2017-2019.

I keep getting FALSE in the result cell

 
Posted : 15/10/2021 5:37 pm
(@catalinb)
Posts: 1937
Member Admin
 

Should look like this:

=IF( OR(G2<78, AND(G2>=2016,K2<=2019)), value_if_true, Value_if_false)

 
Posted : 16/10/2021 11:50 pm
Share: