Functions & Operators

Question 1

AND()

Answer 1

AND Function or && Operator;

Takes at least two arguments and returns true only if all arguments are true.

Question 2

OR()

Answer 2

OR Function or | | Operator;

Takes at least two arguments and returns true if at least one argument is true, and returns false if all arguments are false

Question 3

NOT()

Answer 3

NOT Function or ! Operator;

Returns False for True and True for False

Question 4

IF()

Answer 4

IF Function takes 3 arguments in the format (test, result, alternate)

Define what to test, define the outcome for true, else false.

Question 5

TEXT()

Answer 5

Converts a Percent, Number, Date, Date/Time, picklist, or Currency field into Text without any signs (30% will be 0.3)