How do you do an OR function?

#1

Help with logical functions?

How do you write a function for if something is true OR something else is true?
Is there an easier way to write if something is true AND something else is true than a nested IF()?

I feel like I’m doing crazy workarounds but there must be an easy way to do this.

I looked everywhere I could in the documentation. Thanks.

#2

Hi Jeff! You can use logical operators || (OR) and && (AND) in formulas to evaluate multiple conditions. ! (NOT) can also come in handy.

So for example

IF(isMonday && !isRaining, "A clear Monday", "A rainy Monday")

IF(isSaturday || isSunday, "It's the weekend", "It's not the weekend")

1 Like