:Using COMPLEX function to efficiently generate batch complex numbers-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Using COMPLEX function to efficiently generate batch complex numbers

Using COMPLEX function to efficiently generate batch complex numbers

Author: daogeziyuan • • Table skills • Views 896
```html
  • Picture and text skills
  • Case

Convert real and imaginary coefficients to complex numbers in the form x+yi or x+yj.


Grammar

COMPLEX(real_num, i_num, [suffix])

COMPLEX1.png

COMPLEX function syntax has the following parameters:

Real_num: Required, real coefficient of the complex number.

I_num: required, imaginary coefficient of a complex number.

Suffix: optional, suffix for imaginary coefficients in complex numbers. If omitted, it is assumed to be "i".

Note: All complex functions accept the suffixes "i" and "j", but not "I" or "J". Using uppercase letters causes the #VALUE! error value to be returned

#REF!. All functions that accept two or more complex numbers require that all suffixes match.


Description

￭ If real_num is non-numeric, function COMPLEX returns #VALUE! error value #REF!.

￭ If i_num is non-numeric, function COMPLEX returns #VALUE! error value #REF!.

￭ If the suffix is ​​not "i" or "j", function COMPLEX returns #VALUE! error value #REF!.

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 之于。 Columnist
48 196
single-end

Related Suggestion