Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize

Information types and options

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

The following types of information are available, with options for each type as shown:

Single line of text

Use this information type when you want team members to enter just a few words.

Multiple lines of text

Use this information type when you want team members to type a sentence or more.

Number

Use this information type when you want team members to type a numerical value.

Currency

Use this information type when you want team members to type a monetary value.

Date and Time

Use this information type when you want to store calendar or time-of-day information.

Lookup

Use this information type when you want to make it easy to select information that's already stored in your site.

Choice

Use this information type when you want team members to choose from a set of selections that you have provided.

Yes/No

Use this information type when you want to store true/false information. To indicate a value of "yes," team members select the check box; to indicate a value of "no," team members clear the check box.

Hyperlink or Picture

Use this information type when you want to display a hyperlink to a Web page or display an image from the Web.

Calculated

Use this information type when you want to display a column of information that is based on the results of a formula. The formula can use information from other lists and columns, dates, or numbers. You can use standard mathematical operators. For more information, see About computed and calculated columns .

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft