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!

--------------------
(Ms-Exl-Learner)
--------------------


"Excle" wrote:

How to combine IF and OR formula.

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