TODATE
operator)first name
&
IF(OR(ISBLANK(
first name
),ISBLANK(
last name
)),""," ")
&
last name
SUBSTITUTE(
name
, "-old", " (discontinued)")
TODATE(
important date
+ 7)
(number sold
-
number refunded)
*
price
"1:10 AM"
"1:10:05 AM"
"18:20"
"18:20:15"
1 < 2
1 > 2
1 = 2
AND(logicValue,logicValue,...)
IF(logicValue, trueValue, falseValue)
NOT(TRUE())
returns FALSE()OR(logicValue,logicValue,...)
-1
if number is negative0
if zero1
if positive "Hello " & "World"
CONCATENATE(text1, text2)