Excel

[Excle]

How to combine IF and OR formula.

for example A1=0 B1=1 C1 should show present or "P"

 

[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!

 

[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

 

[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...

 

[Teethless mama]

OR formula:
=IF(OR(EXACT(A1,0),B1=1),"P","")

AND formula:
=IF(A1&B1="01","p","")