Thread: Excel
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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"