Is there a way to have multiple conditions in an IF column cell. I want to create “and” or “or” conditions like IF B17=“True” and B18=“False”.
Hi,
Yes that is possible.
Use the functions AND() or OR()
Like:
=AND(A1,A2)
Or you could also use something lie this:
=IF(A1,TRUE,IF(A2=FALSE,TRUE,FALSE))
All you need is to clarify anystatment, which is either FALSE or TRUE.