How to use the IMLOG2 Function in Excel office 365?
Tags: tousetheimlog2functi, excel, excelfunctions
Published: 2021-08-30 07:22:20

---
title: How to use the IMLOG2 Function in Excel office 365?
published: true
date: 2021-08-28 15:38:29 UTC
tags: ToUseTheIMLOG2Functi,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-imlog2-function-in-excel-office-365/
---

In this blog post, we will explain to you how to **use the IMLOG2 Function In Excel Office 365.** Let’s see them below!! Get an 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)**

## IMLOG2 Function

The **IMLOG2 function** returns the **logarithmic value of the complex number** (inumber) at **base – 2**.

## IMLOG2 Function Syntax

```
=IMLOG2 (inumber)
```

**Syntax Explanation:**

**inumber:** complex number for which you want the complex logarithmic at base 2.

## Example1

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

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

- Then, you need to get the **logarithmic value** of the input **complex number** (inumber) at **base 2**.
- Now, you have to use the following **formula** to calculate **IMLOG2 Function**.

```
=IMLOG2 (A2)
```

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

![](https://geekexcel.com/wp-content/uploads/2021/08/IMLOG2-function-formula-1024x410.png)<figcaption>IMLOG2 Function Formula</figcaption>

- After that, the **formula** returns the **logarithmic value** of the **input complex number(4 + 3i)** at **base – 2.**
- Now, at **base – 2** logarithmic value of a **complex number** is:

```
**(4 + 3i)** **= log2 (4 + 3i) = log2(e)[ln (4 +3i)] = log2(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-3-1024x407.png)<figcaption>Copy to other cells</figcaption>

## Example2

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

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

- Then, you need to get the **logarithmic value** of the input **complex number** (inumber) at **base 2**.
- Now, you have to use the following **formula** to calculate **IMLOG2 Function**.

```
=IMLOG2 (A2)
```

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

- After that, the **formula** returns the **logarithmic value** of the **input complex number(4 + 3i)** at **base – 2.**
- Now, at **base – 2** logarithmic value of a **complex number** is:

```
**(4 + 3i)** **= log2 (4 + 3i) = log2(e)[ln (4 +3i)] = log2(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-1-1024x392.png)<figcaption>Copy to other cells</figcaption>

**Check this too:**

- [IMSQRT Function](https://geekexcel.com/how-to-use-the-imsqrt-function-in-excel-office-365/)
- [IMTAN Function](https://geekexcel.com/how-to-use-the-imtan-function-in-excel-office-365/)

## Wrap-Up

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

**Read Also:**

- **[How to Select Cells Based on Color/Formatting in Excel Office 365?](https://geekexcel.com/how-to-select-cells-based-on-color-formatting-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Tax Rate with Fixed Base with IF Function!](https://geekexcel.com/excel-formulas-to-calculate-the-tax-rate-with-fixed-base-with-if-function/)**
- **[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 IMSUM Function in MS Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-imsum-function-in-ms-excel-365-with-examples/)**