Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
60
Views
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
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