E
Excle
How to combine IF and OR formula.
for example A1=0 B1=1 C1 should show present or "P"
for example A1=0 B1=1 C1 should show present or "P"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Ms-Exl-Learner
This will get the result Present if A1=0 and B1=1. Otherwise it will return
blank result.
=IF(AND(A1=0,B1=1),"PRESENT","")
This will get the result Present if A1=0 OR B1=1. Otherwise it will return
blank result.
=IF(OR(A1=0,B1=1),"PRESENT","")
Remember to Click Yes, if this post helps!
blank result.
=IF(AND(A1=0,B1=1),"PRESENT","")
This will get the result Present if A1=0 OR B1=1. Otherwise it will return
blank result.
=IF(OR(A1=0,B1=1),"PRESENT","")
Remember to Click Yes, if this post helps!
M
Mike H
Hi,
It isn't entirely clear what the OP wants hence your 2 options but note when
testing for zero you will also have to test for a blank cell. Try you formula
with A1 blank
=IF(OR(AND(A1<>"",A1=0),B1=1),"Present","")
Mike
It isn't entirely clear what the OP wants hence your 2 options but note when
testing for zero you will also have to test for a blank cell. Try you formula
with A1 blank
=IF(OR(AND(A1<>"",A1=0),B1=1),"Present","")
Mike
M
Ms-Exl-Learner
Thank you Mike Sir, today i have learned another most basic level concept
about structuring of formula by way of you. Thank you once again for
intimating my mistake and directing me in the right path...
about structuring of formula by way of you. Thank you once again for
intimating my mistake and directing me in the right path...
T
Teethless mama
OR formula:
=IF(OR(EXACT(A1,0),B1=1),"P","")
AND formula:
=IF(A1&B1="01","p","")
=IF(OR(EXACT(A1,0),B1=1),"P","")
AND formula:
=IF(A1&B1="01","p","")