-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Combine OR/AND statement
Many thanks but this does not work - probably fault in my explanation!
I basically want to combine the following 2 OR statements in to an AND:
OR(E3=A$1,F3=A$1)
OR(Z3<2,AB3<2)
When the condition is met return C3. If not return a zero. So for example I want both OR statements to be true to return C3. Otherwise return a zero.
Hope this helps. Many thanks
I basically want to combine the following 2 OR statements in to an AND:
OR(E3=A$1,F3=A$1)
OR(Z3<2,AB3<2)
When the condition is met return C3. If not return a zero. So for example I want both OR statements to be true to return C3. Otherwise return a zero.
Hope this helps. Many thanks
Upvote
0
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Looks like:
=IF(AND(OR(E3 = A$1, F3 = A$1),OR(Z3 < 2, AB3 < 2)),C3,0)
=IF(AND(OR(E3 = A$1, F3 = A$1),OR(Z3 < 2, AB3 < 2)),C3,0)
Upvote
0
