Examples of Formula and Combination Fields

Examples of Formula and Combination Fields

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Display

Custom field

Result in custom field

Number of days since the item was received. (Formula field)

DateValue (Now())-DateValue ([Received]) & " Day(s)"

6 Day(s)

Description of a meeting or appointment in Calendar. (Formula field)

"This meeting occurs " & [Recurrence Pattern] & " in " & [Location]

The meeting occurs every day from 12:00 P.M. to 1:30 P.M. in room 1231

Amount to be charged for a phone call recorded in the Journal at $0.75 a minute. (Formula field)

IIF ([Entry Type] = "Phone call" , Format ([Duration] * .75, "Currency"), "None")

$1.50

Description of a Message Flag. (Formula field)

IIF ( [Flag Status] = "2", [Message Flag] & " " & [Due By],"")

Follow up 3/5/2009 8:00:00 A.M.

The first phone number recorded for a contact, in order of appearance in the formula. (Combination field)

[Business Phone] [Business Phone 2] [Home Phone] [Home Phone 2] [Cell Phone]

(555) 555-1234

A description of a field combined with the field itself. (Combination field)

Task Due: [Due Date]

Task Due: 3/5/2009 8:00:00 A.M.

Show:
© 2016 Microsoft