Thread
:
Excel
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,718
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"
Reply With Quote
Teethless mama
View Public Profile
Find all posts by Teethless mama