Excel for Macintosh 2016
- One or more functions in this workbook are not available in this version of Excel. When recalculated, these functions will ...
- One or more functions in this workbook are not available in versions prior to Excel 2007. When recalculated in earlier versions, ...
- One or more hierarchies have grouped fields in the PivotTable. Slicers cannot be created for hierarchies with grouped fields. ...
- One or more objects in this workbook such as shapes, WordArt, or text boxes may allow text to overflow the object boundaries. ...
- One or more of the fields in this PivotTable corresponding to the slicers chosen have "Include new items in manual filter" ...
- One or more of the PivotTables chosen are created in a version of Excel earlier than Microsoft Excel or in compatibility ...
- One or more of the PivotTables chosen have "Include new items in manual filter" selected for the field corresponding to this ...
- One or more selected columns cannot accept the information you're trying to paste.The information you are trying to paste ...
- One or more slicers cannot be connected to the PivotTables. The "Show calculated members from OLAP server" setting must be ...
- One or more styles with the same name already exist. Do you want to replace them?To overwrite existing styles, click Replace. ...
- One or more tables linked to a server running SharePoint Foundation have been changed in an unexpected way. The data may ...
- One or more worksheets in this workbook have names that contain square brackets:[]. To avoid unexpected results when referencing ...
- Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without ...
- Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without ...
- Opens and evaluates Lotus 1-2-3 files without losing or changing information. With this option selected, Excel evaluates ...
- Organize your data so it's easier to analyze.You can sort the selected data from smallest to largest, largest to smallest, ...
- Other people may not have the latest version of Office.If you plan to share this file you should use this recommended format. ...
- Outline symbols cannot be displayed because there is no outline on the active worksheet. Open the file in Exclusive mode ...
- Password protected sheets cannot be saved in an XML Spreadsheet. To save this file as an XML Spreadsheet, you must first ...
- Password protected workbooks cannot be saved in an XML Spreadsheet. To save this file as an XML Spreadsheet, you must first ...
- Pending changes for this SharePoint list were not loaded. To be able to make changes to this list, either refresh the list ...
- Permanently changes stored values in cells from full precision (15 digits) to whatever level of precision (the number of ...
- PivotTable data cannot be refreshedThe data source may be unavailable or may require data connections that are not compatible ...
- PivotTable report "|" contained incomplete information. To restore the missing information, click OK, and then click Refresh ...
- Plays available sounds that are associated with Microsoft Office application events, such as opening, saving, and printing ...
- Point to Macro on the Tools menu and click Record New Macro to record your actions in Visual Basic for Applications. You ...
- Positional references cannot be used in a calculated item formula while AutoSort by values or AutoShow is on.To turn off ...
- principal,schedule!Returns the future value of an initial principal after applying a series of compound interest rates!is ...
- probability!Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation ...
- probability!This function is available for compatibility with Excel 2008 and earlier.Returns the inverse of the standard ...
- probability,alpha,beta!Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,.), then GAMMA.INV(p,.) ...
- probability,alpha,beta!This function is available for compatibility with Excel 2008 and earlier.Returns the inverse of the ...
- probability,alpha,beta,A,B!Returns the inverse of the cumulative beta probability density function (BETA.DIST)!is a probability ...
- probability,alpha,beta,A,B!This function is available for compatibility with Excel 2008 and earlier.Returns the inverse of ...
- probability,deg_freedom!Returns the inverse of the left-tailed probability of the chi-squared distribution!is a probability ...
- probability,deg_freedom!Returns the inverse of the right-tailed probability of the chi-squared distribution!is a probability ...
- probability,deg_freedom!Returns the left-tailed inverse of the Student's t-distribution!is the probability associated with ...
- probability,deg_freedom!Returns the two-tailed inverse of the Student's t-distribution!is the probability associated with ...
- probability,deg_freedom!This function is available for compatibility with Excel 2008 and earlier.Returns the inverse of the ...
- probability,deg_freedom!This function is available for compatibility with Excel 2008 and earlier.Returns the two-tailed inverse ...
- probability,deg_freedom1,deg_freedom2!Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,.), ...
- probability,deg_freedom1,deg_freedom2!Returns the inverse of the (right-tailed) F probability distribution: if p = F.DIST.RT(x,.), ...
- probability,deg_freedom1,deg_freedom2!This function is available for compatibility with Excel 2008 and earlier.Returns the ...
- probability,mean,standard_dev!Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is ...
- probability,mean,standard_dev!Returns the inverse of the normal cumulative distribution for the specified mean and standard ...
- probability,mean,standard_dev!This function is available for compatibility with Excel 2008 and earlier.Returns the inverse ...
- probability,mean,standard_dev!This function is available for compatibility with Excel 2008 and earlier.Returns the inverse ...
- progID,server,topic1,topic2,.!Retrieves real-time data from a program that supports COM automation!is the name of the ProgID ...
- R1C1_mode,dde_on,sum_info,tips,recent_files,old_menus,user_info,font_name,font_size,default_location,alternate_location,sheet_num,enable_under ...
- range!Counts the number of empty cells in a specified range of cells!is the range from which you want to count the empty ...
- range,criteria!Counts the number of cells within a range that meet the given condition!is the range of cells from which you ...
- range,criteria,average_range!Finds average(arithmetic mean) for the cells specified by a given condition or criteria!is the ...
- range,criteria,sum_range!Adds the cells specified by a given condition or criteria!is the range of cells you want evaluated!is ...
- rate,nper,pmt,fv,type!Returns the present value of an investment: the total amount that a series of future payments is worth ...
- rate,nper,pmt,pv,type!Returns the future value of an investment based on periodic, constant payments and a constant interest ...
- rate,nper,pv,fv,type!Calculates the payment for a loan based on constant payments and a constant interest rate!is the interest ...
- rate,nper,pv,start_period,end_period,type!Returns the cumulative interest paid between two periods!is the interest rate!is ...
- rate,nper,pv,start_period,end_period,type!Returns the cumulative principal paid on a loan between two periods!is the interest ...
- rate,per,nper,pv!Returns the interest paid during a specific period of an investment!interest rate per period. For example, ...
- rate,per,nper,pv,fv,type!Returns the interest payment for a given period for an investment, based on periodic, constant payments ...
- rate,per,nper,pv,fv,type!Returns the payment on the principal for a given investment based on periodic, constant payments ...
- rate,pmt,pv,fv,type!Returns the number of periods for an investment based on periodic, constant payments and a constant interest ...
- rate,pv,fv!Returns the number of periods required by an investment to reach a specified value!is the interest rate per period.!is ...
- rate,value1,value2,.!Returns the net present value of an investment based on a discount rate and a series of future payments ...
- rate,values,dates!Returns the net present value for a schedule of cash flows!is the discount rate to apply to the cash flows!is ...
- real_num,i_num,suffix!Converts real and imaginary coefficients into a complex number!is the real coefficient of the complex ...
- Recalculates formulas before Excel saves your workbook. If Excel takes a long time to save your workbook, you might save ...
- reference!Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE!is a reference to the cell ...
- reference!Returns the column number of a reference!is the cell or range of contiguous cells for which you want the column ...
- reference!Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell!is a reference ...
- reference!Returns the number of sheets in a reference!is a reference for which you want to know the number of sheets it contains. ...
- reference!Returns the row number of a reference!is the cell or a single range of cells for which you want the row number; ...
- ref_text,a1!Returns the reference specified by a text string!is a reference to a cell that contains an A1- or R1C1-style ...
- register_id,argument1,.!module_text,procedure,type_text,argument1,.!Calls a procedure in a dynamic link library or code resource!is ...
- Reminds you to enter summary information - such as title, subject, author, keywords, and comments - for each new workbook ...