Excel 2016 Formulas and Functions

Index

#DIV/0! error, 112

#N/A error, 113

#NAME? error, 113-114

#NULL! error, 115

#NUM! error, 115

#REF! error, 115

#VALUE! error, 115-116

° (degree symbol), 148

3D ranges, 7-8

absolute reference format, 64

account numbers, generating, 154-155, 161

accounting formats, 75

accounts receivable aging worksheet, building, 178-181

adjacent cells, selecting, 10-11

adjusting range name coordinates, 49-51

advantages of Solver, 412

AGGREGATE() function, 315-316

algebraic equations, solving, 361-362

amortization schedules, building, 440-443

dynamic amortizaton schedules, 441-443

fixed-rate amortization schedules, 440-441

Analysis ToolPak

Correlation tool, 281-283

Descriptive Statistics tool, 279-281

Histogram tool, 283-285

loading, ...

Get Excel 2016 Formulas and Functions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.