Formulas > =IMDIV()

How To Use IMDIV() Function in Google Sheets


Returns one complex number divided by another.

Common questions about the IMDIV formula include: What does the IMDIV formula do? What is the syntax of the IMDIV Formula?

The IMDIV Formula can be used appropriately to divide two numbers and return the result.

The IMDIV Formula can be commonly mistyped as IMDIVE, or other variations which give incorrect results.

Some common ways the IMDIV Formula is used inappropriately are if the data being used is not suitable for the formula or if the formula is used incorrectly.

Common pitfalls when using the IMDIV Formula include using incorrect syntax or incorrectly inputting data, or miscalculating results, as the formula can be difficult to understand for those who are not familiar with it.

Common mistakes when using the IMDIV Formula include using it in situations where it does not apply or attempting to cram too much into one formula.

Common misconceptions people might have with the IMDIV Formula are that it is far more complicated than it really is or that it is only suitable for specific data types and cannot be used for others.

How To Actually Use IMDIV() in Sheets

IMDIV(dividend, divisor)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the IMDIV() formula:

54 engineering formulas in excel 2016

This video is about how to create 54 Engineering Functions with Examples in MS Excel Spreadsheet 2016.

Generate a IMDIV() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.