February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Setting Formula Options
Performing calculations is an important part of working with Excel. To customize the way you work with formulas, you can set options on the Formulas pane in the Excel Options dialog box. If you need to create a nested function (one that references itself), you can set a calculation option to enable iterative calculations. Instead of using the A1 cell reference style, you can use the R1C1 cell reference style, which labels columns and row numerically.
Change Formula Options
Click the File tab, and then click Options.
In ...