Excel
 

How to combine IF and OR formula.

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

Excel
 

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"

Excel
 

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" wrote:

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"

Excel
 

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

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


"Mike H" wrote:

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" wrote:

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"

Excel
 

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

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


"Excle" wrote:

How to combine IF and OR formula.

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