Salesforce Formulas & Functions

Question 1

• (Multiply)

Answer 1

Multiplies its values.

Question 2

/ (Divide)

Answer 2

Divides its values.

Question 3

^ (Exponentiation)

Answer 3

Raises a number to a power of a specified number.

Question 4

() (Parentheses)

Answer 4

Evaluates expressions inside parentheses first.

Question 5

= and == (Equal)

Answer 5

Evaluates if two values are equivalent.

Question 6

<> and != (Not Equal)

Answer 6

Evaluates if two values aren’t equivalent.

Question 7

< (Less Than)

Answer 7

Evaluates if a value is less than the next.

Question 8

> (Greater Than)

Answer 8

Evaluates if a value is greater than the next.

Question 9

<= (Less Than or Equal)

Answer 9

Evaluates if a value is less than or equal to the next.

Question 10

> = (Greater Than or Equal)

Answer 10

Evaluates if a value is greater than or equal to the next.

Question 11

&& (AND)

Answer 11

Returns TRUE if both expressions are TRUE.

Question 12

|| (OR)

Answer 12

Returns TRUE if at least one expression is TRUE.

Question 13

& and + (Concatenate)

Answer 13

Connects two or more strings.

Question 14

ABS

Answer 14

Calculates the absolute value of a number.

Question 15

ADDMONTHS

Answer 15

Returns the date that is the indicated number of months before or after a specified date.

Question 16

AND

Answer 16

Returns TRUE if all expressions are true; FALSE otherwise.

Question 17

BEGINS

Answer 17

Returns TRUE if text begins with specified characters.

Question 18

BLANKVALUE

Answer 18

Returns substitute expression if original expression is blank.

Question 19

BR

Answer 19

Inserts a line break in a string.

Question 20

CASE

Answer 20

Checks an expression against values; returns matching result.

Question 21

CASESAFEID

Answer 21

Converts 15-char ID to 18-char case-safe ID.

Question 22

CEILING

Answer 22

Rounds number up to nearest integer, away from zero if negative.

Question 23

CONTAINS

Answer 23

Returns TRUE if text contains specified substring.

Question 24

CURRENCYRATE

Answer 24

Returns currency conversion rate to corporate currency.

Question 25

DATE

Answer 25

Returns date from year, month, and day values.

Question 26

DATEVALUE

Answer 26

Returns date from datetime or text expression.

Question 27

DATETIMEVALUE

Answer 27

Returns datetime from year, month, day, time values.

Question 28

DAY

Answer 28

Returns day of month (1–31).

Question 29

DISTANCE

Answer 29

Calculates distance between two geolocations.

Question 30

EXP

Answer 30

Returns e raised to specified power.

Question 31

FIND

Answer 31

Returns position of text within text.

Question 32

FLOOR

Answer 32

Rounds number down to nearest integer.

Question 33

GEOLOCATION

Answer 33

Returns geolocation from lat/long.

Question 34

GETRECORDIDS

Answer 34

Returns array of selected record IDs.

Question 35

GETSESSIONID

Answer 35

Returns user’s session ID.

Question 36

HOUR

Answer 36

Returns hour of local time.

Question 37

HTMLENCODE

Answer 37

Encodes text for HTML display.

Question 38

HYPERLINK

Answer 38

Creates a hyperlink using URL and link text.

Question 39

IF

Answer 39

Returns one value if expression is TRUE, another if FALSE.

Question 40

IMAGE

Answer 40

Displays an image with alternate text and size.

Question 41

IMAGEPROXYURL

Answer 41

Retrieves secure external images.

Question 42

INCLUDE

Answer 42

Includes s-control snippet.

Question 43

INCLUDES

Answer 43

Returns TRUE if multi-select picklist contains specified value.

Question 44

ISBLANK

Answer 44

Returns TRUE if expression is blank.

Question 45

ISCHANGED

Answer 45

Returns TRUE if field value has changed.

Question 46

ISCLONE

Answer 46

Returns TRUE if record is a clone.

Question 47

ISNEW

Answer 47

Returns TRUE if record is new.

Question 48

ISNULL

Answer 48

Returns TRUE if expression is null.

Question 49

ISNUMBER

Answer 49

Returns TRUE if text is numeric.

Question 50

ISPICKVAL

Answer 50

Returns TRUE if picklist equals specified value.

Question 51

JSENCODE

Answer 51

Encodes text for JavaScript.

Question 52

JSINHTMLENCODE

Answer 52

Encodes text for JavaScript inside HTML.

Question 53

JUNCTIONIDLIST

Answer 53

Returns JunctionIDList from IDs.

Question 54

LEFT

Answer 54

Returns characters from beginning of text.

Question 55

LEN

Answer 55

Returns number of characters in text.

Question 56

LINKTO

Answer 56

Returns relative URL link.

Question 57

LN

Answer 57

Returns natural logarithm.

Question 58

LOG

Answer 58

Returns base 10 logarithm.

Question 59

LOWER

Answer 59

Converts text to lowercase.

Question 60

LPAD

Answer 60

Pads text left with specified characters.

Question 61

MAX

Answer 61

Returns highest number from list.

Question 62

MCEILING

Answer 62

Rounds up toward zero if negative.

Question 63

MFLOOR

Answer 63

Rounds down away from zero if negative.

Question 64

MID

Answer 64

Returns characters from middle of text.

Question 65

MILLISECOND

Answer 65

Returns milliseconds (0–999).

Question 66

MIN

Answer 66

Returns lowest number from list.

Question 67

MINUTE

Answer 67

Returns minute value (0–60).

Question 68

MOD

Answer 68

Returns remainder of division.

Question 69

MONTH

Answer 69

Returns month (1–12).

Question 70

NOT

Answer 70

Returns logical negation.

Question 71

NOW

Answer 71

Returns current datetime.

Question 72

NULLVALUE

Answer 72

Returns substitute if expression is null.

Question 73

OR

Answer 73

Returns TRUE if any expression is TRUE.

Question 74

PARENTGROUPVAL

Answer 74

Returns value from parent grouping in report.

Question 75

PREDICT

Answer 75

Returns Einstein Discovery prediction.

Question 76

PREVGROUPVAL

Answer 76

Returns value from previous grouping in report.

Question 77

PRIORVALUE

Answer 77

Returns previous field value.

Question 78

REGEX

Answer 78

Returns TRUE if text matches regex.

Question 79

REQUIRESCRIPT

Answer 79

Returns JavaScript script tag.

Question 80

REVERSE

Answer 80

Returns reversed text.

Question 81

RIGHT

Answer 81

Returns characters from end of text.

Question 82

ROUND

Answer 82

Rounds number to specified decimal places.

Question 83

RPAD

Answer 83

Pads text right with specified characters.

Question 84

SECOND

Answer 84

Returns seconds (0–60).

Question 85

SQRT

Answer 85

Returns square root of number.

Question 86

SUBSTITUTE

Answer 86

Replaces text in string.

Question 87

TEXT

Answer 87

Converts values to text.

Question 88

TIMENOW

Answer 88

Returns current time (GMT).

Question 89

TIMEVALUE

Answer 89

Returns time value only.

Question 90

TODAY

Answer 90

Returns current date.

Question 91

TRIM

Answer 91

Trims spaces/tabs from text ends.

Question 92

UPPER

Answer 92

Converts text to uppercase.

Question 93

URLENCODE

Answer 93

Encodes text for URL.

Question 94

URLFOR

Answer 94

Returns URL for file, action, or page.

Question 95

VALUE

Answer 95

Converts text to number.

Question 96

VLOOKUP

Answer 96

Looks up related value on custom object.

Question 97

WEEKDAY

Answer 97

Returns weekday (1=Sun, ..., 7=Sat).

Question 98

YEAR

Answer 98

Returns year from date.