• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Formula Basics

Excel makes calculations based on formulas you enter into cells. When you complete the entry of a formula, Excel displays the results of the formula rather than the formula you entered.

Table 2. Basic Mathematical Operators Understood by Excel
Operator Use Example
+ Addition =A1+B10
- Subtraction =A1-B10
- Negation =-A1
* Multiplication =A1*B10
/ Division =A1/B10
^ Exponential =A1^3
% Percentage =20%



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint