Excel Formulas |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Excel Formulas Additional ResourcesExcel Formulas |
Using Excel FormulasYou use Excel formulas to perform all sorts of calculations on the data that you enter. When you enter a formula into a cell, the cell displays the result of the formula.You see the formula itself in the formula bar when the cell is activated.The following table provides a list of operators that you can use in formulas.
Operator Precedence is the set of rules that Excel uses to perform its calculations in a formula. The following table lists the Excel operator precedence. This table shows that exponentiation has the highest precedence (that is, its performed first), and logical comparisons have the lowest precedence. If two operators have the same precedence, Excel performs the calculation from left to right. You can override operator precedence by using parentheses in your formulas.
Creating Excel formulas is a snap as long as you remember to begin every formula with an equal sign (=). For example, suppose that you have a column of numbers that you want to add. Cell B4 seems like a good spot to place your total, right? So just follow these steps:
Your formula disappears from the cell, and the result appears in the cell that you selected. Your formula (if you re-select the cell) appears in the formula bar. |
Excel XP Topics- Tips- Excel Screen Layout - Navigational Techniques - Working with Workbooks - Templates - Working with Worksheets - Moving Around - Move Worksheets - Copy Worksheets - Insert & Delete Cells - Insert & Delete Rows - Insert & Delete Columns - Resize Row - Resize Column - Editing Data - Content Color - Cell Color - Number Formats - Fonts - Alignment - Text Direction - Indent Contents - Merge Cells - Copy - Move - Undo & Redo - Using Zoom - Freeze & Unfreeze Titles - Split Worksheet - Spreadsheet Data - AutoFill - AutoComplete - Comment - Find - Replace - Spellcheck - Formulas - Functions - Password - Sorting - AutoFilter - Advanced Filter - Macros - Charts - Charting - Charting Elements - Gantt Chart - PivotTable - PivotTable Calculations - PivotTable Layout - PivotTable Format - PDF to Excel - PDF-to-Excel Converter - Excel to PDF Converter |