## Engineering functions arithmetic operations of complex numbers

#### Excel Function IMDIV

The IMDIV() function is used to calculate the quotient of two complex numbers.

This function takes two complex numbers as its arguments.

The first parameter is the dividend and the second parameter is the divisor.

Complex Number1 | Complex Number2 | IMDIV |

2+5i | 6+5.7i | 0.591327201051248+0.271572492334647i |

4+2.3i | 1.4+8i | 0.363856882959369-0.43632504548211i |

6+5.7i | 1.7+11i | 0.588425215917346-0.454516102994592i |

1.4+8i | 2+5i | 1.47586206896552+0.310344827586207i |

1.7+11i | 4+2.3i | 1.50775011742602+1.88304368248004i |

#### Excel Function IMPRODUCT

The IMPRODUCT() function is used to determine the product of two complex numbers.

This function takes two complex numbers as its arguments.

Complex Number1 | Complex Number2 | IMPRODUCT |

2+5i | 6+5.7i | -16.5+41.4i |

4+2.3i | 1.4+8i | -12.8+35.22i |

6+5.7i | 1.7+11i | -52.5+75.69i |

1.4+8i | 2+5i | -37.2+23i |

1.7+11i | 4+2.3i | -18.5+47.91i |

#### Excel Function IMSUM

The IMSUM() function is used to calculate the sum of two complex numbers.

This function also takes two complex numbers as its parameters.

Complex Number1 | Complex Number2 | IMSUM |

2+5i | 6+5.7i | 8+10.7i |

4+2.3i | 1.4+8i | 5.4+10.3i |

6+5.7i | 1.7+11i | 7.7+16.7i |

1.4+8i | 2+5i | 3.4+13i |

1.7+11i | 4+2.3i | 5.7+13.3i |

#### Excel Function IMSUB

The IMSUB() function is used to calculate the difference between two complex numbers.

This function takes two complex numbers as its parameters.

The real part and imaginary part are calculated independently.

Complex Number1 | Complex Number2 | IMSUB |

2+5i | 6+5.7i | -4-0.7i |

4+2.3i | 1.4+8i | 2.6-5.7i |

6+5.7i | 1.7+11i | 4.3-5.3i |

1.4+8i | 2+5i | -0.6+3i |

1.7+11i | 4+2.3i | -2.3+8.7i |

#### Excel Function IMSQRT

The IMSQRT() function is used to calculate the square root of the complex number.

This function takes one parameter which is a complex number.

Complex Number2 | IMSQRT |

6+5.7i | 2.67169127468728+1.06674001858003i |

1.4+8i | 2.1819230281679+1.83324523750899i |

1.7+11i | 2.53284311436705+2.17147282782828i |

2+5i | 1.9216093264676+1.30099285300391i |

4+2.3i | 2.07534440491497+0.55412489477722i |