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

Enter 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 Numbers
    • Numbers at a glance
    • Create or open a spreadsheet
    • Replace template placeholders
    • Organize a spreadsheet with sheets
    • Customize your app
    • Undo and redo changes
  • Add and edit tables
    • Add and delete tables
    • Working with rows and columns
    • Add content to table cells
    • Format table cells
    • Create a custom cell format
    • Add controls to cells
    • Merge and unmerge cells
    • Add a comment to a cell
    • Add conditional highlighting to cells
    • Change the look of a table
    • Change the look of table text
    • Save a table as a new style
    • Move, resize, and lock a table
    • Sort data in a table
    • Filter data
  • Enter 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
  • Add and edit charts
    • Add or delete a chart
    • Scatter charts and bubble charts
    • Interactive charts
    • 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
  • Add images, shapes, and media
    • Objects overview
    • Add and edit images
    • Add and edit shapes
    • Add video and audio
    • Change the look of an object
    • Create object styles
    • Resize, rotate, and flip an object
    • Align and position objects
    • Layer, group, and lock objects
  • Add, edit, and format text
    • Add text
    • Copy and paste text
    • Change the look of text
    • Align text
    • Adjust character spacing and formatting
    • Add color or a border to a text box
    • Check spelling
    • Find and replace text
    • Replace text automatically
    • Add comments and highlight text
    • Create bulleted and numbered lists
    • Format punctuation
    • Use paragraph styles
    • Format Chinese, Japanese, or Korean text
  • Manage spreadsheets
    • Save and rename a spreadsheet
    • Save a spreadsheet in another format
    • Lock a spreadsheet
    • Protect a spreadsheet with a password
    • Add custom templates
    • Delete a spreadsheet
    • Move a spreadsheet to or from iCloud
  • Share and print
    • Use iCloud with Numbers
    • Share and edit a spreadsheet on iCloud
    • Send a copy of a spreadsheet
    • Print a spreadsheet
    • Transfer files using iTunes
  • Keyboard shortcuts
Help for Apple products Copyright © 2014 Skydocu Inc. All rights reserved.