English
Change Language
  • English
  • Bahasa Indonesia
  • Bahasa Melayu
  • Català
  • Čeština
  • Dansk
  • Deutsch
  • Español
  • Français
  • Hrvatski
  • Italiano
  • Magyar
  • Nederlands
  • Norsk (bokmål)‎
  • Polski
  • Português
  • Português (Portugal)‎
  • Română
  • Slovenčina
  • Suomi
  • Svenska
  • Tiếng Việt
  • Türkçe
  • Ελληνικά
  • Русский
  • Українська
  • עברית
  • العربية
  • ภาษาไทย
  • 한글
  • 日本語
  • 简体中文
  • 繁體中文
Pages logo Pages

Formulas and functions

Calculations
Calculate values using data in table cells You can create formula or function cells that…

Types of arguments and values
This page defines many of the terms used to describe the functions in the Function…

String operators and wildcard characters


  • Get started in Pages
    • Pages at a glance
    • Create and open a document
    • Undo and redo changes
    • Quick navigation
    • Customize the toolbar
    • Zoom a document or view Pages full screen
  • Edit text
    • Add text
    • Copy and paste text
    • Change the look of text
    • Adjust character spacing and formatting
    • Use paragraph styles
    • Create bulleted and numbered lists
    • Create links for websites and email addresses
    • Format punctuation
    • Format Chinese, Japanese, or Korean text
    • Use bidirectional text
  • Format documents
    • Set paper size and orientation
    • Add, delete, and rearrange pages
    • Set margins
    • Change the flow of text
    • Convert the document type
    • Add headers, footers, and page numbers
    • Create sections
    • Add a background color and border
    • Align text
    • View formatting marks and layout
    • Show and hide rulers
    • Add footnotes and endnotes
    • Use EndNote and MathType
    • Add a table of contents
  • Add images, shapes, and media
    • Anchor objects to the page or to text
    • Add and edit images
    • Add and edit shapes
    • Add lines and arrows
    • Add video and audio
    • Add a caption to an object
    • Add and align text in an object
    • Place objects in the background
    • Change the look of an object
    • Use object styles
    • Resize, rotate, and flip an object
    • Set ruler preferences
    • Use alignment guides
    • Align and position objects
    • Layer, group, and lock objects
  • Add tables and charts
    • Tables
      • Add and delete tables
      • Add rows and columns
      • Add and edit table cell content
      • Format table cells
      • Create a custom cell format
      • Merge and unmerge cells
      • Add a comment to a cell
      • Add images and other objects to table cells
      • Add conditional highlighting to cells
      • Change the look of a table
      • Change the look of table text
      • Save a table as a new style
      • Resize, move, and lock a table
      • Format tables for bidirectional text
      • Sort data in a table
    • Formulas and functions
      • Calculations
      • Types of arguments and values
      • String operators and wildcard characters
        • Ways to use the string operator and wildcards
        • Functions that accept conditions and wildcards as arguments
    • Charts
      • Add and delete a chart
      • Move, resize, and rotate a chart
      • Modify chart data
      • Adjust a chart’s markings and labels
      • Change a chart’s type
      • Change the look of a chart
      • Save a chart as a new style
  • Use writing and editing tools
    • Check spelling
    • Look up words
    • Find and replace text
    • Replace text automatically
    • Add comments and highlight text
    • Show word count and other document statistics
    • Track changes
  • Manage documents
    • Save and rename a document
    • Locate a document
    • Save a document in another format
    • Lock a document
    • Password-protect a document
    • Add custom templates
    • Move a document to or from iCloud
    • Delete a document
  • Share and print documents
    • Use iCloud with Pages
    • Share and edit a document with others
    • Send a copy of a document
    • Print a document
    • Print envelopes, labels, and business cards
    • Share files over a remote server
    • Transfer files using iTunes
  • Keyboard shortcuts
Help for Apple products Copyright © 2014 Skydocu Inc. All rights reserved.