Index
A note on the digital index
A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.
Symbols
- & (ampersand), in formulas, When working with complex conditions, break your formula apart into columns
- * (asterisk), multiplication operator, Formulas work with your data
- [] (brackets), in structured references, Excel’s Tables make your references quick and easy
- : (colon), in cell references, Refer to a bunch of cells using a range
- $ (dollar sign), in cell references, Use absolute references to prevent shifting on copy/paste
- = (equals sign), Formulas work with your data, IF gives results based on a Boolean condition
- in logical expressions, IF gives results based on a Boolean condition
- preceding formulas, Formulas work with your data
- ! (exclamation point), in cell references, Excel got the right answer using a more sophisticated reference, Excel got the right answer using a more sophisticated reference
- / (forward slash), division operator, Formulas work with your data
- > (greater than sign), IF gives results based on a Boolean condition
- >= (greater than or equal sign), IF gives results based on a Boolean condition
- < (less than sign), IF gives results based on a Boolean condition
- <= (less than or equal sign), IF gives results based on a Boolean condition ...
Get Head First Excel 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.