How to combine IF, AND, OR functions
Solved/Closed
MLC10
Posts
1
Registration date
Friday 5 February 2021
Status
Member
Last seen
5 February 2021
-
5 Feb 2021 à 19:57
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Feb 2021 à 11:36
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Feb 2021 à 11:36
Related:
- How to combine IF, AND, OR functions
- Combine notifications viber - Guide
- Combine social media feeds - Guide
- How many if functions can be nested in excel - Guide
- Functions of wifi - Guide
- Hard drive functions - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
23 Feb 2021 à 11:36
23 Feb 2021 à 11:36
Hi MLC10,
Sure thing.
Here you go:
=IF(AND(OR(K2=1,K2=9),W2="VANCOUVER",AA2="CANADA"),M2+5,M2)
Best regards,
Trowa
Sure thing.
Here you go:
=IF(AND(OR(K2=1,K2=9),W2="VANCOUVER",AA2="CANADA"),M2+5,M2)
Best regards,
Trowa
