- To see the version of Numbers on your Mac, choose Numbers About Numbers (from the Numbers menu at the top of your screen). To browse this guide, click Table of Contents near the top of this page. You can also download the guide from Apple Books (where available). If you need more help, visit the Numbers Support website.
- Numbers 5 for Mac advances the app, making it more useful for more purposes with less effort, but it’s still a shadow of full-feature business spreadsheet programs. Nonetheless, the set of.
The Numbers spreadsheet program, which is a free download from the App Store, can help you organize data and analyze important financial decisions for home and business — everything from a household budget to your company’s sales statistics!
Numbers can open, edit, and save spreadsheets created with Microsoft Excel. Note, however, that not all Excel features are supported within Numbers.
Download Apple Numbers for Mac to spreadsheet app. Create gorgeous spreadsheets with the all-new Numbers for Mac. Get started with one of many Apple-designed templates for your home budget. What does Numbers do? Create gorgeous spreadsheets with Numbers for Mac. Get started with one of many Apple-designed templates for your home budget, checklist, invoice, mortgage calculator, and more. Add tables, charts, text, and images anywhere on the free-form canvas. Apple today updated its iWork apps for the Mac to version 10.1, introducing new features for Pages, Keynote, and Numbers. The Pages app now.
How to create a new Numbers document
Like Pages, Numbers ships with a selection of templates you can modify quickly to create a new spreadsheet. For example, after a few modifications, you can easily use the Budget, Loan Comparison, and Mortgage templates to create your own spreadsheets.
To create a spreadsheet project file, follow these steps:
- Click the Launchpad icon on the Dock.
- Click the Numbers icon.
- Click the New Document button at the lower-left corner of the Open dialog that appears.
Numbers displays the Choose a Template window, shown in the figure. (To display the Choose a Template window and start a new Numbers project at any time, just choose File → New.) - From the list on the left, click the type of document you want to create.
The document thumbnails in the center are updated with templates that match your choice. - Click the template that most closely matches your needs.
- Click the Choose button to open a new document using the template you selected.
How to open an existing spreadsheet file
If you see an existing Numbers document in a Finder window or the All My Files location (or you find it using Spotlight), just double-click the Numbers document icon to open it. Numbers automatically loads and displays the spreadsheet.
It’s equally easy to open a Numbers document from within the program. Follow these steps:
- If Numbers isn’t already running, click the Numbers icon from the Launchpad to run the program.
- Press Command +O to display the Open dialog.
- If the spreadsheet is stored in your iCloud Drive, click the Numbers item under the iCloud heading in the sidebar at the left of the dialog and then double-click the desired document thumbnail to load the spreadsheet.
All three of Apple’s productivity applications — Pages, Numbers, and Keynote — feature an Open dialog that can display the contents of your iCloud Drive as well as your iMac’s internal drive. - If the document is stored on your iMac’s internal drive, your network, or one of your Favorites locations, click the desired drive or folder in the sidebar at the left of the dialog. Drill down through folders and subfolders until you locate the desired Numbers document, and double-click the document thumbnail to load the spreadsheet.
If you’re unsure where the document is, click in the Search box at the top of the Open dialog and type a portion of the document name or even a word or two of text it contains. Note that you can choose to search your drive, your iCloud Drive, or both.
If you want to open a spreadsheet you’ve been working on over the last few days, choose File→ Open Recent to display Numbers documents that you’ve worked with recently.
Save those spreadsheets!
Thanks to the macOS Auto-Save feature, you no longer have to fear losing a significant chunk of work because of a waning battery or a coworker’s mistake. However, if you’re not a huge fan of retyping data, period, you can also save your spreadsheets manually after making a major change. Follow these steps to save your spreadsheet to a specific drive or folder on your iMac:
1. Press Command +S.
If you’re saving a document that hasn’t yet been saved, the Save As sheet appears.
2. Type a filename for your new spreadsheet.
3. Open the Where pop-up menu and choose a location in which to save the file.
Common locations are your iCloud Drive, Desktop, Documents folder, and Home folder.
Common locations are your iCloud Drive, Desktop, Documents folder, and Home folder.
If the location you want isn’t listed in the Where pop-up menu, click the down-arrow button next to the Save As text box to display the full Save As dialog. Click the desired drive in the Devices list at the left of the dialog, and then click folders and subfolders until you reach the desired location. Alternatively, type the folder name in the Spotlight search box at the top right, and double-click the desired folder in the list of matching names. (As a bonus, you can also create a new folder in the full Save As dialog.)
4. Click Save.
After you save a Numbers document for the first time, you can create a version of that document by choosing File → Save. To revert the current document to an older version, choose File→ Revert To. You can choose to revert to the last saved version, or you can click Browse All Versions to look through multiple versions of the document and choose one of those to revert to.
Exploring the Numbers window
Apple has done a great job of minimizing the complexity of the Numbers window. Figure 18-2 illustrates these major points of interest:
- Sheets tabs: When a project contains multiple spreadsheets, Numbers indicates the spreadsheets in the Sheets tabbed bar at the top of the window. To switch among spreadsheets in a project, click the desired tab.
- Sheet canvas: Numbers displays the rows and columns of your spreadsheet in this section of the window; you enter and edit cell values within the sheet canvas.
- Toolbar: The Numbers toolbar keeps the most common commands you’ll use within easy reach.
- Inspector: Located at the right side of the Numbers window, the Inspector displays editing controls for the object that’s currently selected, regardless of whether it’s a selection of text, a table, or a single cell. (If you enter an equal sign [=] into a cell to create a formula, the Inspector displays the Function list, where you can specify a calculation that Numbers should perform.)
Navigating and Selecting Cells in a Numbers Spreadsheet
You can use the scrollbars to move around your spreadsheet, but when you enter data into cells, moving your fingers from the keyboard is a hassle. Numbers has various handy navigation shortcut keys you can employ, as shown. After you commit these keys to memory, your productivity level will shoot straight to the top.
Movement Shortcut Keys in Numbers
Key or Key Combination | Where the Cursor Moves |
Left arrow (←) | One cell to the left |
Right arrow (→) | One cell to the right |
Up arrow (↑) | One cell up |
Down arrow (↓) | One cell down |
Home | To the beginning of the active worksheet |
End | To the end of the active worksheet |
Page Down | Down one screen |
Page Up | Up one screen |
Return | One cell down (also works within a selection) |
Tab | One cell to the right (also works within a selection) |
Shift+Enter | One cell up (also works within a selection) |
Shift+Tab | One cell to the left (also works within a selection) |
You can also use the mouse or trackpad to select cells in a spreadsheet:
- To select a single cell, click it.
- To select a range of adjacent cells, click a cell at any corner of the range you want and drag in the direction you want.
- To select a column of cells, click the alphabetic heading button at the top of the column.
- To select a row of cells, click the numeric heading button at the far left of the row.
Entering and Editing Data in a Numbers Spreadsheet
After you navigate to the cell in which you want to enter data, you’re ready to type your data. Follow these steps to enter That Important Stuff:
- Either click the cell or press the spacebar.
A cursor appears, indicating that the cell is ready to hold any data you type. - Enter your data. Spreadsheets can use both numbers and alphabetic characters within a cell; either type of information is considered data in the Spreadsheet World.
- When you’re ready to move on, press Return (to save the data and move one cell down) or press Tab (to save the data and move one cell to the right).
Make a mistake? No big deal:
- To edit data: Click within the cell that contains the data error (to select the cell), and then click the cell again to display the insertion cursor. Drag the insertion cursor across the characters to highlight them, and then type the replacement data.
- To delete characters: Select the cell, and then highlight the characters and press Delete.
Selecting the Correct Number Format in Numbers
After you enter your data (in a cell, row, or column), you might need to format it so that it appears correctly. For example, say you want certain cells to display a specific type of number, such as a dollar amount, percentage, or date. Numbers gives you a healthy selection of number-formatting possibilities.
Characters and formatting rules — such as decimal places, commas, and dollar and percentage notation — are part of number formatting. If your spreadsheet contains units of currency, such as dollars, format it as such. Then all you need to do is type the numbers, and the currency formatting is applied automatically.
To specify a number format, follow these steps:
- Select the cells, rows, or columns you want to format.
- Click the Format toolbar button.
- Click the Cell tab in the Inspector.
- From the Data Format pop-up menu, choose the type of formatting you want to apply, as shown here.
Aligning cell text in Numbers
You can also change the alignment of text in the selected cells. The default alignment is flush left for text and flush right for numeric data. Follow these steps:
- Select the cells, rows, or columns you want to format.
- Click the Format toolbar button.
- Click the Text tab of the Inspector to display the settings shown here.
- Click the corresponding Alignment button to choose the type of formatting you want to apply.
You can choose left, right, center, and justified (as well as the defaults of text left and numbers right). You also can format text to be aligned at the top, center, or bottom of a cell.
Do you need to set apart the contents of some cells? For example, you might need to create text headings for some columns and rows or to highlight the totals in a spreadsheet. To change such formatting, select the cells, rows, or columns you want to format, and then open the Font Family, Font Size, or Font Color buttons on the Text tab.
Formatting Numbers with shading
Shading the contents of a cell, row, or column is helpful when your spreadsheet contains subtotals or logical divisions. Follow these steps to shade cells, rows, or columns:
- Select the cells, rows, or columns you want to format.
- Click the Format toolbar button.
- Click the Cell tab of the Inspector.
- Click the triangle next to the Fill heading, and choose a shading option from the Fill pop-up menu.
The following figure shows the controls for a gradient fill. - Click the color box to select a color for your shading.
Numbers displays a color picker (also shown). - Click to select a color.
- After you achieve the effect you want, click the color box again to close the color picker.
You can also add a custom border to selected cells, rows, and columns from the Cell tab. Click the triangle next to the Border heading to select just the right border.
Inserting and deleting rows and columns in Numbers
What’s that? You forgot to add a row, and now you’re three pages into your data entry? No problem. You can easily add — or delete — rows and columns. First, select the row or column adjacent to where you want to insert (or delete) a row or column, and do one of the following:
- For a row: Right-click and choose Add Row Above, Add Row Below, or Delete Row from the shortcut menu that appears.
- For a column: Right-click and choose Add Column Before, Add Column After, or Delete Column from the shortcut menu that appears.
If you select multiple rows or columns, right-click and choose Add. Numbers inserts the same number of new rows or columns you selected.
You can also insert rows and columns via the Table menu at the top of the Numbers window.
The Formula Is Your Friend
It’s time to talk about formulas, which are equations that calculate values based on the contents of cells you specify in your spreadsheet. For example, if you designate cell A1 (the cell in column A at row 1) to hold your yearly salary and cell B1 to hold the number 12, you can divide the contents of cell A1 by cell B1 (to calculate your monthly salary) by typing this formula into any other cell:
= A1 / B1
Formulas in Numbers always start with an equal sign, and they may include one or more functions as well. A function is a preset mathematical, statistical, or engineering calculation that will be performed, like figuring the sum or average of a series of cells.
“So what’s the big deal, Mark? Why not use a calculator?” Sure, you could. But maybe you want to calculate your weekly salary. Rather than grab a pencil and paper, you can simply change the contents of cell B1 to 52, and — boom! — the spreadsheet is updated to display your weekly salary.
That’s a simple example, of course, but it demonstrates the basics of using formulas (and the reason why spreadsheets are often used to predict trends and forecast budgets). It’s the what-if tool of choice for everyone who works with numeric data.
To add a simple formula within a spreadsheet, follow these steps:
1. Select the cell that will hold the result of your calculation.
2. Type = (the equal sign).
The Formula Box appears within the confines of the cell.
3. Click the Format button on the Numbers toolbar to display the available functions in the Inspector, as shown.
4. Click the category of calculation you want from the left column of the Inspector.
Instead of scrolling through the entire function library, it’s easier to choose a category — such as Financial for your budget spreadsheet — to filter the selection. (Alternatively, you can click in the Search box and type a function name or keyword.)
To display more information about a specific function, click it in the right column of the Inspector. Choosing the SUM function brings up a description at the bottom of the Inspector.
5. After you select the perfect function in the right column, click the Insert Function button.
The function appears in the Formula box, along with any arguments it requires.
In case you’re unfamiliar with the term argument, it refers to a value specified in a cell that a formula uses. For example, the SUM formula adds the contents of each cell you specify to produce a total; each of those cell values is an argument.
In case you’re unfamiliar with the term argument, it refers to a value specified in a cell that a formula uses. For example, the SUM formula adds the contents of each cell you specify to produce a total; each of those cell values is an argument.
6. Click an argument button in the formula, and click the cell that contains the corresponding data.
Numbers automatically adds the cell you indicated to the formula. Repeat this step for each argument in the formula.
7. After you finish, click the Accept button — the green checkmark — to add the formula to the cell.
That’s it! Your formula is now ready to work behind the scenes, doing math for you so the correct numbers appear in the cell you specified.
Adding Visual Punch with a Chart
Sometimes, you just have to see something to believe it, so it can help to use the data you’ve added to a spreadsheet to generate a professional-looking chart. After you’ve entered the data you want to chart, follow these steps:
1. Select the adjacent cells you want to chart by dragging.
To choose individual cells that aren’t adjacent, you can hold down the Command key as you click.
2. Click the Chart button on the Numbers toolbar.
The Chart button bears the symbol of a bar graph.
Numbers displays the thumbnail menu shown. Note that you can display different categories of charts by clicking one of the three tabs at the top (2D/3D/Interactive), and you can scroll the menu to reveal additional thumbnails by using the left- and right-arrow buttons.
Numbers displays the thumbnail menu shown. Note that you can display different categories of charts by clicking one of the three tabs at the top (2D/3D/Interactive), and you can scroll the menu to reveal additional thumbnails by using the left- and right-arrow buttons.
3. Click the thumbnail for the chart type you want.
Numbers inserts the chart as an object within your spreadsheet so you can move the chart. You can drag using the handles that appear on the outside of the object box to resize your chart.
With your chart selected, click the Format toolbar button to display your old friend the Inspector, complete with the controls you can use to customize your chart’s appearance. For example, you can change the colors and add (or remove) the title and legend.
4. To change the default title, click the title box to select it; click it again to edit the text.
How to print your Numbers spreadsheet
You can easily send a Numbers spreadsheet to a USB or shared network printer -- Mac uninstall sling tv app. or, if you’d rather create an electronic copy of the document as an Adobe PDF, you can click the PDF button that appears on the Numbers Print dialog and select a location where the file will be saved.
To print a Numbers spreadsheet on your default printer, follow these steps:
1. Choose File→ Print from the Numbers menu bar to display the Print Setup window.
Because a Numbers document can contain multiple spreadsheets, you can select a specific spreadsheet to print (by clicking it in the grid and clicking the Print This Sheet radio button at the bottom of the window), or you can print all spreadsheets in the document (by clicking the Print All Sheets radio button).
2. Click the desired page orientation.
Spreadsheets with a large number of columns are often printed in landscape orientation to ensure that everything fits on the page. You can also scale the spreadsheet so it automatically fits on the page by clicking the Fit button (next to the Content Scale slider).
3. Click Print at the bottom of the window.
Numbers displays the Print dialog shown. To display additional settings, click the Show Details button at the bottom of the sheet.
4. Click in the Copies field, and enter the number of copies you need.
5. Select the pages to print:
- To print the entire spreadsheet, select All.
- To print a range of selected pages, select the From radio button, and enter the starting and ending pages.
6. Click the Print button to send the document to your printer.
Click the Share menu item to send a copy of your spreadsheet masterpiece to others. Click the Collaborate button on the toolbar to allow others to view or edit your spreadsheet from your iCloud Drive as a shared document.
DATE
Combines separate values for year, month, and day and returns a date/time value.
DATEDIF
Returns the number of days, months, or years between two dates.
DATEVALUE
Converts a date text string and returns a date/time value. This function is provided for compatibility with other spreadsheet programs.
DAY
Returns the day of the month for a given date/time value.
DAYNAME
Returns the name of the day of the week from a date/time value or a number. Day 1 is Sunday.
DAYS360
Returns the number of days between two dates based on twelve 30‑day months and a 360‑day year.
EDATE
Returns a date that is some number of months before or after a given date.
EOMONTH
Returns a date that is the last day of the month some number of months before or after a given date.
HOUR
Returns the hour for a given date/time value.
MINUTE
Returns the minutes for a given date/time value.
MONTH
Returns the month for a given date/time value.
MONTHNAME
Returns the name of the month from a number. Month 1 is January.
NETWORKDAYS
Returns the number of working days between two dates. Working days exclude weekends and any other specified dates.
NOW
Returns the current date/time value from the system clock.
SECOND
Returns the seconds for a given date/time value.
TIME
Converts separate values for hours, minutes, and seconds into a date/time value.
TIMEVALUE
Returns the time as a decimal fraction of a 24‑hour day from a given date/time value or from a text string.
TODAY
Returns the current system date. The time is set to 12:00 a.m.
WEEKDAY
Returns a number that is the day of the week for a given date.
WEEKNUM
Returns the number of the week within the year for a given date.
WORKDAY
Returns the date that is the given number of working days before or after a given date. Working days exclude weekends and any other dates specifically excluded.
YEAR
Returns the year for a given date/time value.
YEARFRAC
Finds the fraction of a year represented by the number of whole days between two dates.
DUR2DAYS
Converts a duration value to a number of days.
DUR2HOURS
Converts a duration value to a number of hours.
DUR2MILLISECONDS
Converts a duration value to a number of milliseconds.
DUR2MINUTES
Converts a duration value to a number of minutes.
DUR2SECONDS
Converts a duration value to a number of seconds.
DUR2WEEKS
Converts a duration value to a number of weeks.
DURATION
Combines separate values for weeks, days, hours, minutes, seconds, and milliseconds and returns a duration value.
STRIPDURATION
Evaluates a given value and returns either the number of days represented, if a duration value; or the given value. This function is included for compatibility with other spreadsheet applications.
BASETONUM
Converts a number of the specified base into a number in base 10.
BESSELJ
Returns the integer Bessel function Jn(x).
BESSELY
Returns the integer Bessel function Yn(x).
BIN2DEC
Converts a binary number to the corresponding decimal number.
BIN2HEX
Converts a binary number to the corresponding hexadecimal number.
BIN2OCT
Converts a binary number to the corresponding octal number.
CONVERT
Converts a number from one measurement system to its corresponding value in another measurement system.
DEC2BIN
Converts a decimal number to the corresponding binary number.
DEC2HEX
Converts a decimal number to the corresponding hexadecimal number.
DEC2OCT
Converts a decimal number to the corresponding octal number.
DELTA
Determines whether two values are exactly equal.
ERF
Returns the error function integrated between two values.
ERFC
Returns the complementary ERF function integrated between a given lower bound and infinity.
GESTEP
Determines if one value is greater than or exactly equal to another value.
HEX2BIN
Converts a hexadecimal number to the corresponding binary number.
HEX2DEC
Converts a hexadecimal number to the corresponding decimal number.
HEX2OCT
Converts a hexadecimal number to the corresponding octal number.
NUMTOBASE
Converts a number from base 10 into a number in the specified base.
OCT2BIN
Converts an octal number to the corresponding binary number.
OCT2DEC
Converts an octal number to the corresponding decimal number.
OCT2HEX
Converts an octal number to the corresponding hexadecimal number.
ACCRINT
Calculates the accrued interest added to the purchase price of a security and paid to the seller when the security pays periodic interest.
ACCRINTM
Calculates the total accrued interest added to the purchase price of a security and paid to the seller when the security pays interest only at maturity.
BONDDURATION
Calculates the weighted average of the present value of the cash flows for an assumed par value of $100.
BONDMDURATION
Calculates the modified weighted average of the present value of the cash flows for an assumed par value of $100.
COUPDAYBS
Returns the number of days between the beginning of the coupon period in which settlement occurs and the settlement date.
COUPDAYS
Returns the number of days in the coupon period in which settlement occurs.
COUPDAYSNC
Returns the number of days between the settlement date and the end of the coupon period in which settlement occurs.
COUPNUM
Returns the number of coupons remaining to be paid between the settlement date and the maturity date.
CUMIPMT
Returns the total interest included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.
CUMPRINC
Returns the total principal included in loan or annuity payments over a chosen time interval based on fixed periodic payments and a fixed interest rate.
DB
Returns the amount of depreciation of an asset for a specified period using the fixed‑declining balance method.
DDB
Returns the amount of depreciation of an asset based on a specified depreciation rate.
DISC
Returns the annual discount rate of a security that pays no interest and is sold at a discount to its redemption value.
EFFECT
Returns the effective annual interest rate from the nominal annual interest rate based on the number of compounding periods per year.
FV
Download Numbers For Mac
Returns the future value of an investment based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.
INTRATE
Returns the effective annual interest rate for a security that pays interest only at maturity.
IPMT
Returns the interest portion of a specified loan or annuity payment based on fixed, periodic payments and a fixed interest rate.
IRR
Returns the internal rate of return for an investment that is based on a series of potentially irregular cash flows that occur at regular time intervals.
ISPMT
Returns the interest portion of a specified loan or annuity payment based on fixed, periodic payments and a fixed interest rate. This function is provided for compatibility with tables imported from other spreadsheet applications.
MIRR
Returns the modified internal rate of return for an investment that is based on a series of potentially irregular cash flows that occur at regular time intervals. The rate earned on positive cash flows and the rate paid to finance negative cash flows can differ.
NOMINAL
Returns the nominal annual interest rate from the effective annual interest rate based on the number of compounding periods per year.
NPER
Returns the number of payment periods for a loan or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.
NPV
Returns the net present value of an investment based on a series of potentially irregular cash flows that occur at regular time intervals.
PMT
Returns the fixed periodic payment for a loan or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.
PPMT
Returns the principal portion of a specified loan or annuity payment based on fixed periodic payments and a fixed interest rate.
PRICE
Returns the price of a security that pays periodic interest per $100 of redemption (par) value.
PRICEDISC
Returns the price of a security that is sold at a discount to redemption value and does not pay interest per $100 of redemption (par) value.
PRICEMAT
Returns the price of a security that pays interest only at maturity per $100 of redemption (par) value.
PV
Returns the present value of an investment or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.
RATE
Returns the interest rate of an investment, loan, or annuity based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and a fixed interest rate.
RECEIVED
Returns the maturity value for a security that pays interest only at maturity.
SLN
Returns the amount of depreciation of an asset for a single period using the straight‑line method.
SYD
Returns the amount of depreciation of an asset for a specified period using the sum‑of‑the‑years‑digits method.
VDB
Returns the amount of depreciation of an asset over a chosen time interval, based on a specified depreciation rate.
YIELD
Returns the effective annual interest rate for a security that pays regular periodic interest.
YIELDDISC
Returns the effective annual interest rate for a security that is sold at a discount to redemption value and pays no interest.
YIELDMAT
Returns the effective annual interest rate for a security that pays interest only at maturity.
AND
Returns TRUE if all arguments are true; otherwise it returns FALSE.
FALSE
Returns the Boolean value FALSE. This function is included for compatibility with tables imported from other spreadsheet applications.
IF
Returns one of two values depending on whether a specified expression evaluates to a Boolean value of TRUE or FALSE. https://newzilla210.weebly.com/blog/running-mobile-apps-on-mac.
IFERROR
Returns a value that you specify if a given value evaluates to an error; otherwise it returns the given value.
ISBLANK
Returns TRUE if the specified cell is empty; otherwise it returns FALSE.
ISERROR
Returns TRUE if a given expression evaluates to an error; otherwise it returns FALSE.
ISEVEN
Returns TRUE if the value is even (leaves no remainder when divided by 2); otherwise it returns FALSE.
ISODD
Returns TRUE if the value is odd (leaves a remainder when divided by 2); otherwise it returns FALSE.
NOT
Returns the opposite of the Boolean value of a specified expression.
OR
Returns TRUE if any argument is true; otherwise it returns FALSE.
TRUE
Returns the Boolean value TRUE. This function is included for compatibility with tables imported from other spreadsheet applications.
ABS
Returns the absolute value of a number or duration.
CEILING
Rounds a number away from zero to the nearest multiple of the specified factor.
COMBIN
Returns the number of different ways you can combine a number of items into groups of a specific size, ignoring the order within the groups.
EVEN
Rounds a number away from zero to the next even number.
EXP
Returns e (the base of natural logarithms) raised to the specified power.
FACT
Returns the factorial of a number.
FACTDOUBLE
Returns the double factorial of a number.
FLOOR
Rounds a number toward zero to the nearest multiple of the specified factor.
GCD
Returns the greatest common divisor of the specified numbers.
INT
Returns the nearest integer that is less than or equal to the number.
LCM
Returns the least common multiple of the specified numbers.
LN
Returns the natural logarithm of a number, the power to which e must be raised to result in the number.
LOG
Returns the logarithm of a number using a specified base.
LOG10
Returns the base‑10 logarithm of a number.
MOD
Returns the remainder from a division.
MROUND
Rounds a number to the nearest multiple of a specified factor.
MULTINOMIAL
Returns the closed form of the multinomial coefficient of the given numbers.
ODD
Rounds a number away from zero to the next odd number.
PI
Returns the approximate value of π (pi), the ratio of a circle’s circumference to its diameter.
POLYNOMIAL
Evaluates a polynomial at a given point.
POWER
Returns a number raised to a power.
PRODUCT
Returns the product of one or more numbers.
QUOTIENT
Returns the integer quotient of two numbers.
RAND
Returns a random number that is greater than or equal to 0 and less than 1.
RANDBETWEEN
Returns a random integer within the specified range.
ROMAN
Converts a number to Roman numerals.
ROUND
Returns a number rounded to the specified number of places.
ROUNDDOWN
Returns a number rounded toward zero (rounded down) to the specified number of places.
ROUNDUP
Returns a number rounded away from zero (rounded up) to the specified number of places.
SERIESSUM
Computes and returns the sum of a power series.
SIGN
Returns 1 when a given number is positive, –1 when it is negative, and 0 when it is zero.
SQRT
Returns the square root of a number.
SQRTPI
Returns the square root of a number multiplied by π (pi).
SUM
Returns the sum of a collection of numbers.
SUMIF
Returns the sum of a collection of numbers, including only numbers that satisfy a specified condition.
SUMIFS
Returns the sum of the cells in a collection where the test values meet the given conditions.
SUMPRODUCT
Returns the sum of the products of corresponding numbers in one or more ranges.
SUMSQ
Returns the sum of the squares of a collection of numbers.
SUMX2MY2
Returns the sum of the difference of the squares of corresponding values in two collections.
SUMX2PY2
Returns the sum of the squares of corresponding values in two collections.
SUMXMY2
Returns the sum of the squares of the differences between corresponding values in two collections.
TRUNC
Truncates a number to the specified number of digits.
ADDRESS
Constructs a cell address string from separate row, column, and table identifiers.
AREAS
Returns the number of ranges the function references.
CHOOSE
Returns a value from a collection of values based on a specified index value.
COLUMN
Returns the column number of the column containing a specified cell.
COLUMNS
Returns the number of columns included in a specified range of cells.
HLOOKUP
Returns a value from a range of rows by using the top row of values to pick a column and a row number to pick a row within that column.
INDEX
Returns the value in the cell located at the intersection of the specified row and column within a range of cells.
INDIRECT
Returns the contents of a cell or range referenced by an address specified as a string.
INTERSECT.RANGES
Returns a range that is the intersection of the specified ranges.
LOOKUP
Finds a match for a given search value in one range, then returns the value in the cell with the same relative position in a second range.
MATCH
Returns the position of a value within a range.
OFFSET
Returns a range of cells that is the specified number of rows and columns away from the specified base cell.
ROW
Returns the row number of the row containing a specified cell.
ROWS
Returns the number of rows included in a specified range of cells.
TRANSPOSE
Returns a vertical range of cells as a horizontal range of cells, or vice versa.
UNION.RANGES
Returns a range that represents a range representing the union of the specified ranges.
VLOOKUP
Returns a value from a range of columns by using the left column of values to pick a row and a column number to pick a column in that row.
AVEDEV
Returns the average of the difference of a collection of numbers from their average (arithmetic mean).
AVERAGE
Returns the average (arithmetic mean) of a collection of numbers.
AVERAGEA
Returns the average (arithmetic mean) of a collection of values, including text and Boolean values.
AVERAGEIF
Returns the average (arithmetic mean) of the cells in a range that meet a given condition.
AVERAGEIFS
Returns the average (arithmetic mean) of the cells in a collection that meet all the given conditions.
BETADIST
Returns the cumulative beta distribution probability value.
BETAINV
Returns the inverse of the given cumulative beta distribution probability value.
BINOMDIST
Returns the individual term binomial distribution probability of the specified form.
CHIDIST
Returns the one‑tailed probability of the chi‑square distribution.
CHIINV
Returns the inverse of the one‑tailed probability of the chi‑square distribution.
CHITEST
Returns the value from the chi‑square distribution for the given data.
CONFIDENCE
Returns a value for creating a statistical confidence interval for a sample from a population with a known standard deviation.
CORREL
Returns the correlation between two collections using linear regression analysis.
COUNT
Returns the number of its arguments that contain numbers, numeric expressions, or dates.
COUNTA
Returns the number of its arguments that are not empty.
COUNTBLANK
Returns the number of cells in a range that are empty.
COUNTIF
Returns the number of cells in a range that satisfy a given condition.
COUNTIFS
Returns the number of cells in one or more ranges that satisfy given conditions (one condition per range).
COVAR
Returns the covariance of two collections.
CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a given value.
DEVSQ
Returns the sum of the squares of deviations of a collection of numbers from their average (arithmetic mean).
EXPONDIST
Returns the exponential distribution of the specified form.
FDIST
Returns the F probability distribution.
FINV
Returns the inverse of the F probability distribution.
FORECAST
Returns the forecasted y value for a given x value based on sample values using linear regression analysis.
FREQUENCY
Returns an array of how often data values occur within a range of interval values.
GAMMADIST
Returns the gamma distribution in the specified form.
GAMMAINV
Returns the inverse gamma cumulative distribution.
GAMMALN
Returns the natural logarithm of the gamma function, G(x).
GEOMEAN
Returns the geometric mean.
HARMEAN
Returns the harmonic mean.
INTERCEPT
Returns the y‑intercept of the best‑fit line for the collection using linear regression analysis.
LARGE
Returns the nth‑largest value within a collection. The largest value is ranked number 1.
LINEST
Returns an array of the statistics for a straight line that best fits the given data using the least squares method.
LOGINV
Returns the inverse of the log‑normal cumulative distribution function of x.
LOGNORMDIST
Returns the log‑normal distribution.
MAX
Returns the largest number in a collection.
MAXA
Returns the largest number in a collection of values that may include text and Boolean values.
MEDIAN
Returns the median value in a collection of numbers. The median is the value where half the numbers in the collection are less than the median and half are greater.
MIN
Returns the smallest number in a collection.
MINA
Returns the smallest number in a collection of values that may include text and Boolean values.
MODE
Returns the most frequently occurring value in a collection of numbers.
NEGBINOMDIST
Returns the negative binomial distribution.
NORMDIST
Returns the normal distribution of the specified function form.
NORMINV
Returns the inverse of the cumulative normal distribution.
NORMSDIST
Returns the standard normal distribution.
NORMSINV
Returns the inverse of the cumulative standard normal distribution.
PERCENTILE
Returns the value within a collection that corresponds to a particular percentile.
PERCENTRANK
Returns the rank of a value in a collection as a percentage of the collection.
PERMUT
Returns the number of permutations for a given number of objects that can be selected from a total number of objects.
POISSON
Returns the probability that a specific number of events will occur using the Poisson distribution.
PROB
Returns the probability of a range of values if you know the probabilities of the individual values.
QUARTILE
Returns the value for the specified quartile of a given collection.
RANK
Returns the rank of a number within a range of numbers.
SLOPE
Returns the slope of the best‑fit line for the collection using linear regression analysis.
SMALL
Returns the nth‑smallest value within a range. The smallest value is ranked number 1.
STANDARDIZE
Returns a normalized value from a distribution characterized by a given mean and standard deviation.
STDEV
Returns the standard deviation, a measure of dispersion, of a collection of values based on their sample (unbiased) variance.
STDEVA
Returns the standard deviation, a measure of dispersion, of a collection of values that may include text and Boolean values, based on the sample (unbiased) variance.
STDEVP
Returns the standard deviation, a measure of dispersion, of a collection of values based on their population (true) variance.
Numbers App Download For Windows
STDEVPA
Returns the standard deviation, a measure of dispersion, of a collection of values that may include text and Boolean values, based on the population (true) variance.
TDIST
Returns the probability from the Student’s t‑distribution.
TINV
Returns the t value (a function of the probability and degrees of freedom) from the Student’s t‑distribution.
TTEST
Returns the probability associated with a Student’s t‑test, based on the t‑distribution function.
VAR
Returns the sample (unbiased) variance, a measure of dispersion, of a collection of values.
VARA
Returns the sample (unbiased) variance, a measure of dispersion, of a collection of values, including text and Boolean values.
VARP
Returns the population (true) variance, a measure of dispersion, of a collection of values.
VARPA
Returns the sample (unbiased) variance, a measure of dispersion, of a collection of values, including text and Boolean values.
WEIBULL
Returns the values of the Weibull distribution.
ZTEST
Returns the one‑tailed probability value of the Z‑test.
CHAR
Returns the character that corresponds to a decimal Unicode character code.
CLEAN
Removes most common nonprinting characters (Unicode character codes 0–31) from text.
CODE
Returns the decimal Unicode number of the first character in a specified string.
CONCATENATE
Joins (concatenates) strings.
DOLLAR
Returns a string formatted as a dollar amount from a given number.
EXACT
Returns TRUE if the argument strings are identical in case and content.
FIND
Returns the starting position of one string within another.
FIXED
Rounds a number to the specified number of decimal places and then returns the result as a string value.
LEFT
Returns a string consisting of the specified number of characters from the left end of a given string.
LEN
Returns the number of characters in a string.
LOWER
Returns a string that is entirely lowercase, regardless of the case of the characters in the specified string.
MID
Returns a string consisting of the given number of characters from a string starting at the specified position.
PROPER
Returns a string where the first letter of each word is uppercase and all remaining characters are lowercase, regardless of the case of the characters in the specified string.
REPLACE
Returns a string where a specified number of characters of a given string have been replaced with a new string.
REPT
Returns a string that contains a given string repeated a specified number of times.
RIGHT
Returns a string consisting of the given number of characters from the right end of a specified string.
SEARCH
Returns the starting position of one string within another, ignoring case and allowing wildcards.
SUBSTITUTE
Returns a string where the specified characters of a given string have been replaced with a new string.
T
Returns the text contained in a cell. This function is included for compatibility with tables imported from other spreadsheet applications.
TRIM
Returns a string based on a given string, after removing extra spaces.
UPPER
Returns a string that is entirely uppercase, regardless of the case of the characters in the specified string.
VALUE
Returns a number value even if the argument is formatted as text.
ACOS
Returns the inverse cosine (arccosine) of a number.
ACOSH
Returns the inverse hyperbolic cosine (hyperbolic arccosine) of a number.
ASIN
Returns the arcsine (the inverse sine) of a number.
ASINH
Returns the inverse hyperbolic sine of a number.
ATAN
Returns the inverse tangent (arctangent) of a number.
ATAN2
Returns the angle, relative to the positive x‑axis, of the line passing through the origin and the specified point.
ATANH
Returns the inverse hyperbolic tangent of a number.
COS
Returns the cosine of an angle that is expressed in radians.
COSH
Returns the hyperbolic cosine of a number.
DEGREES
Returns the number of degrees in an angle expressed in radians.
RADIANS
Returns the number of radians in an angle expressed in degrees.
SIN
Returns the sine of an angle that is expressed in radians.
SINH
Returns the hyperbolic sine of the specified number.
TAN
Returns the tangent of an angle that is expressed in radians.
TANH
Numbers App Macos
Mac os sierra best mail app. Returns the hyperbolic tangent of the specified number.