Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Exponents in excel is the same exponential function in excel such as in mathematics where a number is raised to a power or exponent of another number, exponents in excel are used by two methods one is by using the power function in excel worksheet which takes two arguments one as the number and another as the exponent or we can use the exponent symbol from the keyboard.
Exponents in Excel (Table of Contents)
Exponents in Excel Formula
In a mathematical calculation, when a number is required to multiply by itself for a given number of times, it will be represented as a base number to the power of the exponent. Here, the base number is the number which is to be multiplied and the exponent number is the number of times the base number should be multiplied.
26. Here 2 is the base number and 6 is an exponent which means 2 should be multiplied 6 times. i.e. 2 x 2 x 2 x 2 x 2 x 2. It can be read as 2 to the power of 6.
The other way to write this is using the “Caret” symbol i.e. “^” that is Base ^ Exponent
The above example can be written as 2^6 which again means 2 to be multiplied 6 times.
If you are an Excel user, then definitely you would need to find out the way to express the exponent while showing the calculations. This can be done in three ways by using the formulas. To write the exponent in excel, text mode can be used. Now, let me explain to you how to write the exponent in excel and how to use the power function.
How to Use Exponents in Excel Formula?
Following are the ways with which Exponents in excel formula can be used.
#1 – Exponent in Excel Using the Power Function
Here let’s learn how to use the power function in excel. It is one of the functions/formula available in excel.
Like other formulas, the power formula also should start with the “=” sign.
The formula of the Power function is.
- Number: It is the base number.
- Power: It is the exponent.
Below given is the simple examples of using the power function.
The result is shown below.
The first row has the base number of 6 and exponent as 3 which is 6 x6 x 6 and the result is 216 which can be derived using a power function in excel.
In the formula, the base number and the exponents can be used directly instead of the cell reference. (As shown in the example below).
Here in the first row 5 is multiplied twice i.e. 5 x 5.
The result is 25.
This power function can be used to find out the Square root, Cube root or nth root of the number. The exponents used to find the square root is (1/2), the cube root is (1/3) and the nth root is (1/n). The nth number means any given number. Below given are a few examples.
In this table, the first row has the base number like 49 which is the square root of 7 (7 x 7) and 125 is the cube root of 5 (5 x5 x5) and 244 is the 6th root of 2.5 (2.5 x 2.5 x 2.5 x 2.5 x 2.5 x 2.5).
The results are given below.
The output column shows the results.
The first row in the above table is finding the square root, the second row is for cube root and the third row is the nth root of the number.
#2 – Exponent in Excel Using Base Power
Using the “Caret” symbol, the power function can be applied using the Base number and exponent. It is a shorthand used for the power function.
You can find this caret symbol in the keyboard in Number 6 key (^). Hold Shift along with 6 to use this symbol. Apply the formula “=Base ^ Exponent”.
As explained above in the previous examples of a Power function, the formula using the caret can be applied to take the cell references or by entering the base number and the exponent with a caret.
Below table shows the example of using the cell references with (^).
The result is shown below:
Using the base number and exponent using (^) is shown in the below table.
The result is shown below:
The caret operator can be used in finding out the square root, cube root and nth root of the number where the exponents are (1/2), (1/3), (1/n). [As shown in the below tables].
Now the result is shown below:
Now the result is shown below:
#3 – Exponent in Excel Formula Using EXP Function
Another way of calculating the exponent is by using the function EXP. This is one of the functions in excel.
The syntax of the formula is.
Here the number refers to “e” the base number and exponent is the given number. It is e to the power of a given number. Here “e” is the constant value which is 2.718. So, the value of e will be multiplied with the times of exponent (given number).
Here you can see that the number given in the formula is 5 which means the value of “e” ie., 2.718 is multiplied 5 times and the result is 148.413.
To write or express the exponents in excel, we need to use text-based exponents. To do this,
Step 1 – Select the cells where you want to input the exponent’s value. Change the format of the selected cells to “Text”.
This can be done either by selecting the cells and choosing the Text option from the dropdown list in “Home” tab under “Number” section or right click on the selected cells and select “Format Cells” option to select the Text option under “Number” tab.
Step 2 – Now enter both Base number and Exponent in the cell next to next without any space
- Select the exponent number only (as shown below).
Step 3 – Right-click on the cell and select Formal cells option.
Step 4 – In the pop-up window, check the box for Superscript under Effects category. Hit OK.
(In Excel, we have an option called superscript or subscript to show the mathematical values or formulas).
Step 5 – Click Enter and you can see the result as below.
All these are examples of how Exponents can be expressed in Excel. This text-based mode of showing the exponents can also be used for showing other mathematical formulas or values.
Below shown is the ways the exponents can be used in Excel formula
Things to Remember about Exponents in Excel Formula
- Whenever the number is shown as Base to the power of the exponent, it will be shown as text only and this cannot be considered for any numerical calculations
- When the exponent given in a formula is a large number, the result shown will be in scientific or exponential notation. (Example: =10^100 gives the result as 1E+100)
- Superscript (to the power of) is an option available in Excel to express the exponents and other mathematical formulas
- In Excel functions, adding the spaces between the values doesn’t make any difference. So you can add a space in between the digits for easy readability.
This has been a guide to Exponents in Excel. Here we discuss how to use the Exponents in Excel Formula using Caret, EXP and Power function along with practical examples and downloadable excel template. You may learn more about excel from the following articles –