How to use the IMLOG10 Function in Excel office 365?
Tags: tousetheimlog10funct, excel, excelfunctions
Published: 2021-08-31 01:21:38

---
title: How to use the IMLOG10 Function in Excel office 365?
published: true
date: 2021-08-30 19:42:23 UTC
tags: ToUseTheIMLOG10Funct,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imlog10-function-in-excel-office-365/
---

In this article, you will learn how to use the **IMLOG10 Function In Excel Office 365**  using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of  **MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## IMLOG10 Function

The **IMLOG10 function** returns the **complex common logarithm of the complex number** (inumber) having both **real & imaginary parts**.

## IMLOG10 Function Syntax

```
=IMLOG10 (inumber)
```

**Syntax Explanation:**

**inumber:** complex number on which common logarithm is performed.

## Example1

- Firstly, you have to  **create a sample data**  with input  **complex number**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-44.png)<figcaption>Sample data</figcaption>

- Then, you need to get the **complex common logarithm** of the **input complex number**.
- Now, you have to use the following  **formula ** to calculate  **IMLOG10 Function**.

```
=IMLOG10 (A2)
```

**A2:** complex number (inumber) provided as a cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/IMLOG10-Function.png)<figcaption>IMLOG10 Function</figcaption>

- After that, the  **formula ** returns the **complex common logarithm** of the **input complex number**.
- Now, the **common logarithm of a complex number ** is:

```
(4 + 3i) = log10 (4 + 3i) = log10(e)[ln (4 +3i)] = log10(e)[ln √42 +32 + i tan-1( 3 / 4 )]
```

- At last, you have to copy the  **formula ** to the other remaining cells using  **Ctrl + D**  shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Copy-to-other-cells-4.png)<figcaption>Copy to other cells</figcaption>

## Example2

- Firstly, you have to  **create a sample data**  with input  **complex number**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Sample-data-6.png)<figcaption>Sample data</figcaption>

- Then, you need to get the **complex common logarithm** of the **input complex number**.
- Now, you have to use the following  **formula ** to calculate  **IMLOG10 Function**.

```
=IMLOG10 (A2)
```

**A2:** complex number (inumber) provided as a cell reference.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-IMLOG10.png)<figcaption>IMLOG10 Function</figcaption>

- After that, the  **formula ** returns the **complex common logarithm** of the **input complex number**.
- Now, the **common logarithm of a complex number ** is:

```
(4 + 3i) = log10 (4 + 3i) = log10(e)[ln (4 +3i)] = log10(e)[ln √42 +32 + i tan-1( 3 / 4 )]
```

- At last, you have to copy the  **formula ** to the other remaining cells using  **Ctrl + D**  shortcut key.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Copy-to-other-cells-2.png)<figcaption>Copy to other cells</figcaption>

**Check this too:**

- [IMLOG2 Function](https://geekexcel.com/how-to-use-the-imlog2-function-in-excel-office-365/)
- [IMSUB Function](https://geekexcel.com/how-to-use-imsub-function-in-ms-excel-365-with-examples/)
- [IMSUM Function](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)
- [IMSQRT Function](https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/)

## Wrap-Up

Hope you understood how to **use the IMLOG10 Function In Excel Office 365**. Please feel free to state your query or feedback for the above article. Thank you so much for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[Find the Most Common or Frequently Used Value(Word or Number) in a List in Excel](https://geekexcel.com/find-the-most-common-or-frequently-used-valueword-or-number-in-a-list-in-excel/)**
- **[Formula to Find the Most Common or Frequently used Values In Excel!!](https://geekexcel.com/formula-to-find-the-most-common-or-frequently-used-values-in-excel/)**
- **[How to Use IMSUM Function in MS Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)**
- **[How to use the IMSQRT Function in Excel Office 365?](https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/)**
- **[How to use the IMDIV Function in Excel office 365?](https://geekexcel.com/how-to-use-the-imdiv-function-in-excel-office-365/)**