Excel Functions Tutorials

- Excel Formulas Cheatsheet
- Excel
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Concatenate Excel Function
- RIGHT Function in Excel
- LEN in Excel
- LEFT Function in Excel
- Search Function in Excel
- TEXT Function in Excel
- PROPER in Excel
- MID in Excel
- Trim in Excel
- CLEAN Excel Function
- EXACT Excel Function
- REPT Function in Excel
- CODE Excel Function
- FIND Function in Excel
- VALUE Function in Excel
- Char Function In Excel
- Substitute Function in Excel
- Substring in Excel

- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- TRANSPOSE Excel Function
- Row Function in Excel
- OFFSET Excel Function
- VLOOKUP with Multiple Criteria
- IFERROR with VLOOKUP in Excel
- Fixing VLOOKUP Errors
- Alternatives to Vlookup

- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- DSUM
- COMBIN Excel Function
- INT Excel Function (Integer)
- TANH in Excel

- Date and Time Function in Excel
- Statistical Function in Excel
- AVERAGE Excel Function
- CORREL Excel Function
- COUNT Excel Function
- COUNTIF Excel Function
- FREQUENCY Excel Function
- MAX Excel Function
- MEDIAN Excel Function
- GROWTH Excel Function
- SLOPE Function in Excel
- TREND Function in Excel
- SMALL Function in Excel
- MODE Excel Function
- LARGE Excel Function
- PERCENTILE Excel Function
- LINEST Excel Function
- T-TEST in Excel
- QUARTILE Excel Function
- FORECAST Excel Function
- MIN in Excel
- Standard Deviation in Excel
- COUNTIF with Multiple Criteria
- Mean vs Median
- NORM.S.INV Function in Excel
- NORMDIST in Excel
- Variance vs Standard Deviation

- Information Functions in Excel
- Excel Charts
- Column Chart in excel
- Stacked Column Chart
- Pie Chart in Excel
- Area Chart in Excel
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Histogram Excel Chart
- Waterfall Chart in Excel
- Pareto Chart in Excel
- Bubble Chart in Excel
- Gantt Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Dynamic Chart in Excel

- Excel Tools
- Watch Window in Excel
- List Box in Excel VBA
- Conditional Formatting in Excel
- Data Table in Excel
- Data Validation Excel
- Paste Special in Excel (With Top 10 Shortcuts)
- One Variable Data Table in Excel
- Two-Variable Data Table in Excel
- Scenario Manager in Excel
- Solver in Excel
- Name Range in Excel
- Dynamic Named Range in Excel
- Sort Data in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Auto Format Excel
- Track Changes in Excel
- Text to Columns in Excel
- Merge Cells in Excel
- Lock Cells in Excel
- Scroll Bars in Excel
- Spell Check in Excel
- Filters in Excel
- Auto Filter In Excel
- Advanced Filter in Excel
- Recording Macros in Excel
- Add-Ins in excel
- Excel Fill Handle
- AutoFill in Excel
- Excel Tables
- Radio Button in Excel
- Combo Box in Excel and VBA
- Checkbox in Excel

- Excel Tips
- How to Unhide Columns in Excel?
- Convert Date to Text in Excel
- Top 20 Keyboard Shortcuts in Excel
- Convert Numbers to Text in Excel
- Show Formula in Excel
- Absolute Reference in Excel
- Relative References in Excel
- Superscript in Excel
- Subscript in Excel
- Formula Errors in Excel
- Convert Text to Numbers in Excel
- Insert Multiple Rows in Excel
- Remove Blank Rows in Excel
- Highlight Every Other Row in Excel
- External Links in Excel
- Insert Hyperlinks in Excel
- Remove Hyperlinks in Excel
- Combine Cells in Excel
- Remove Duplicates in Excel
- Random Numbers in Excel
- Drop Down List in Excel
- Refresh Pivot Table in Excel
- Column Sort in Excel
- Hiding a Column in Excel
- Count Unique Values in Excel
- CAGR Formula in Excel
- Equations in Excel
- How to Delete Pivot Table?
- Excel Subtraction Formula
- Excel Extensions
- Hide Formula in Excel
- Numbering in Excel
- Auto Numbering in Excel
- Row Limit in Excel
- Delete Row Shortcut in Excel
- Arrays in Excel VBA
- Array Formulas in Excel
- Dynamic Tables in Excel
- Convert Columns to Rows in Excel
- Formatting in Excel
- Print Comments in Excel
- Excel vs Google Sheets

**LOG Excel Function (Table of Contents)**

## LOG In Excel

LOG function in Excel computes the logarithm of a number to the base that we specify. LOG in Excel is categorized as a Math/Trigonometry function in Excel. LOG in Excel always returns a numeric value.

In mathematics, the logarithm is opposite of the exponentiation. It means the logarithmic value of any given number is the exponent to which the base must be raised, to produce that number. For example,

**2 ^{5 }= 32**

For a given number 32, 5 is the exponent to which base 2 has been raised to produce the number 32. So, a LOG of 32 will be 5.

Mathematically, we write it as log_{2}32 =5, that is a LOG of 32 to the base 2 is 5.

### LOG Formula in Excel

**Number:** is a positive real number (should not be a 0) for which we want to calculate logarithm in excel

**Base:** it is an optional argument, it is base to which the logarithmic value is calculated, and LOG function in Excel by default takes the base as 10.

**How to Use LOG Function in Excel?**

LOG in Excel is very simple and easy to use. Let understand the working of LOG function in Excel by some LOG Formula example.

The Logarithmic function is used for mathematical operations and is widely used in financial statistics. In business analytics, LOG in Excel is often used with other tools for regression analysis and plotting graphs for data representation. Logarithmic functions are used for graphical representation when the rate of change in the data increases or decreases quickly.

The POWER function returns the result of a number raised to a power, so inversely, the LOG function in Excel returns the Power (exponent) to which the base is raised.

### LOG in Excel Example #1

For example, 4^{5 = }1024, using POWER function we would write it as POWER(4,5) = 1024, now if we nest this formula of POWER function inside the log function in Excel providing the base as 4, we would get the exponent which is passed as a second argument in the POWER function.

The output of the POWER function is passed as the first argument to the LOG function in Excel and it further computes the result.

LOG in Excel can be used in many ways; Logarithm helps to solve real-world problems. For example, the magnitude of an Earthquake is calculated as the logarithm of the amplitude of the seismic waves generated.

The Magnitude of an Earthquake is represented by a LOG formula:

R=log_{10}(A/A_{0})

Where A is the measurement of the amplitude earthquake wave and A_{0 }is the smallest amplitude recorded of seismic activity, so if we have the values of A and A_{0}, we can easily calculate the magnitude of the Earthquake in Excel by the LOG formula:

**=LOG((A/A _{0}),10)**

### LOG in Excel Example #2

Suppose, we have samples of solutions labeled with alphabets A, B, C….L. We are provided with the [H^{+}] ion concentration in µ mol/liter in Excel sheet in Column B and we want to find which solution is acidic, alkaline or water. The Data table is given below:

The acidic and the basic nature of a chemical solution are measured by its pH value, which is calculated by the formula:

**pH=-log _{10}[H+]**

If pH is less than 7, it is an acidic solution, if a pH is greater than 7, it is a basic(alkaline) solution and when pH is 7, it is neutral that neither acidic nor basic, like water.

So, to find the acidic and basic nature of the solution we will use the LOG in Excel and will check it the logarithmic value is less than, greater than or equal to 7.

Since the given hydrogen concentration is in a unit of µmol/liter. Hence, the value will be **X*10 ^{-6}**

So, the LOG in excel to find the nature of the solution

**=IF(-(LOG(B4*POWER(10,-6),10))<7,”Acidic”,IF(-(LOG(B4*POWER(10,-6),10))>7,”Alkaline”,”Water”))+**

Computing the value of **Log of [H ^{+}] concentration * Power(10,-6)** since the unit used is µmol/liter and checking, using the IF function if value is greater than, less than or equal to 7.

Using the formula in other cells we have,

**Output:**

** **

**T**he solution labeled with I, has the pH value equal to 7, hence it is pure water.

### LOG in Excel Example #3

In computer science, every algorithm has its efficiency measured in terms of the how fast it fetches the result or gives an output. This efficiency is calculated technically by the time complexity. Time complexity describes the amount of the time an algorithm will take to execute.

There are different algorithms for searching an item in a list of an array, for example, Bubble sort, Quick sort, Merge sort, Binary Sort, etc. Every algorithm has different efficiency in terms of its time complexity.

To understand, consider an example,

we have a sorted array,

Now, we want to search the number 18, from the array of the given number.Array Pointer

This algorithm follows the divide and rule methodology, where it divides the set equally at each step of iteration and searches for the item when it finds the item, the loops (iteration) gets terminated and returns the value.

**Step 1:**

**Step 2:**

** ****Step 3:**

** ****Step 4:**

Number 18, was found at position 9, and it took 4 steps to search the item using the binary search algorithm.

So, the complexity of the Binary search is calculated as **log _{2}N, where n is the number of items**

**=LOG(16,2) = 4**

Hence, to search an item in an array of items, the binary search will take **log _{2}N **steps.

Suppose, we are provided with a list that contains the total number of items, and to search an item from these items we are using the Binary search algorithm. Now, we have to find how many step it will take to find an item from the given items.

Again, we will use the LOG in Excel to calculate the complexity.

**The LOG formula will be: = ROUND(LOG(A6,2),0)**

The result could be in decimal so, we have rounded the result of 0 places of digits.

Concatenating with the “String Steps Required are”, we have

**=”Steps Required are”&” “&ROUND(LOG(A6,2),0)**

To search for an item, from an array of 1000000 items, the binary search will take only 20 steps only.

LOG functions are also widely used in economics, for stock price indexing graphs, and these graphs are very useful to check the prices going down or up.

You can download this LOG in Excel Template here – LOG Function Excel Template

### Recommended Articles

This has been a guide to LOG in Excel. Here we discuss the LOG Formula in Excel and how to use LOG function in Excel along with LOG examples and downloadable excel templates. You may also look at these useful functions in excel –

## Leave a Reply