is a logical function that returns one value if the condition is true and another if the condition is false.

OR$($condition $1,$ condition $2..)$

AND $($condition $1,$ condition $2...)$

$TO($value if true, value if false$)$

IF$($condition$,$ value if true, value if false$)$