-
How to use functions Add(), Subtract(), Multiply() and Divide() to calculate with numbers
-
How to provide an output based on a condition using IfElse()
-
How to compare one value to multiple values and return results accordingly using Switch()
-
How to convert text to upper case using Upper()
-
How to format date and time using FormatDateTime()
-
How to display the current date using Now()
-
How to add days, weeks, months, quarters, or years to a selected date using DateAdd()
-
How to subtract days, weeks, months, quarters or years from a selected date using DateSubtract()
-
How to transform a date and time in text format into a date object using DateValue()
-
How to format a number input using FormatNumber()
-
How to convert text to lower case using Lower()
-
How to convert text to proper case using Proper()
-
How to convert text to sentence case using SentenceCase()
-
How to translate terms or sentences using Translate()
-
How to join two pieces of text together using Concat()
-
How to join multiple pieces of text with a separator using StringJoin()
-
How to separate multiple pieces of text using StringSplit()
-
How to use functions GreaterThan(), LessThan() and Equals() with number values
-
How to generate a unique number using Ticks()
-
How to get the value from a specific column and row within a Data Source using DataSources[]
-
How to get the value from a specific column and row within an External Data Source using ExternalDataSources[]
-
How to reverse the value of a True/False statement using Not()
-
How to use the And() and Or() operators with multiple True/False arguments
-
How to determine if two values are equal using Equals()
-
How to determine if the source text contains a specific search value using Contains()