Browsing all articles tagged with function

IMSQRT Excel Formula

Author Zaheer    Category Formulas     Tags ,

In the following tutorials, here you will learn and be guided on the usage and syntax of the IMSQRT functions present in the Excel application.

Description:

The IMSQRT function returns square root of complex number a plus b (a+b) or x plus yi (x+yi) in text format

Syntax:

The IMSQRT function syntax is as follow:

= IMSQRT (inumber)

Where: iNumber is complex number for which you like the square root.

Note:

When the complex number that you enter as argument is in the format other than the x+iy or x+jy, then the IMSQRT function returns as the #NUM! Error value

Excel IMSQRT Function Samples: 

Here are some of the examples of the Excel IMSQRT function used to calculate square root of various complex numbers… The spread sheet on left shows that formula and the spread sheet on right shows the result:

Formulas                    Results:

=IMSQRT( “I” )           0.707106781186548+0.707106781186547i

=IMSQRT( “2-i” )         1.45534669022535-0.343560749722512i

=IMSQRT( “5+2i” )              2.27872385417085+0.438842116902255i

=IMSQRT( 6 )             2.44948974278318

=IMSQRT( “-2-4i” )              1.11178594050284-1.79890743994787i

IMSQRT Function Common Errors: 

  • #NUM! – It happen when the supplied NUMBER argument is not identified as the complex number
  • #NAME? – It happen when the Analysis Tool Pak adds on is not enabled in the Excel. You will have to let the add-on if you like to use Excel engineering functions.

For you to do this in Excel 2003, you have to do the following:

  • From the Tools drop down menu, you have to choose the option Analysis Tool Pak and then click OK.
  • An add-on window will pop out and from here, you need to choose the option Analysis Tool Pal and then click OK

For you to do this in Excel 2007, you have to do the following:

  • Click Microsoft button just on top of the left spreadsheet and then choose Excel Options button
  • From Menu, select Add on located at the left hand side
  • In Manage box, you have to choose Excel Add- Ins and then click GO
  • An Add-on window will pop out. From here, you have to choose option Analysis Tool Pak and then click OK

Suppose, if you like to look for the square root of complex number ‘ 1 plus 2i’, then the formula for IMSQRT Function must be written as the following:

= IMSQRT (“1+2i”)

The mentioned function above returns to the square root of complex number ‘`1 + 2i’ and the square root which return would also be complex number “1.2720196+0.7861513i”.

You can supply cell reference as well and the argument to IMSQRT Function.

For instance, the formula =IMSQRT (C4)

It will find the square root of complex number which is present in example above. As a result, this is the process how you can look for the square root of the given complex number with the use of the IMSQRT function presented in the Excel 2010 Application.

These are the essential things that you can accomplish in utilizing IMSQRT function in Excel. There are countless tutorials that you can locate online through various Microsoft site. You can look through online and learn further about IMSQRT function. Additionally, you can also look and find for a few more formulas to use.

OCT2BIN Excel Formula

Author Zaheer    Category Formulas     Tags ,

Description:

Hexadecimals base 16, decimals base ten, octal base eight, and the binary base 2 numbering systems are commonly used in computer science and engineering. Thus, Excel has provided function to change the numerical values ??of each of the systems. The function transfers an Excel file OCT2BIN octal base 8 in a binary system base 2 numbers.

Syntax:

The configuration of this particular function is as follows:

= OCT2BIN (number, [places])

It is

Where:

- The number of arguments is the octal binary becomes

And,

- The arguments are not optional arguments specifying the numbers of character as the binary number repurchased. In case this is more than the least, then the binary number is padded with the use of leading 0.

If omitted, returns the binary number by using the least number of seats.

Note down that number of argument should not exceed 10 characters or 40 bits long. Most noteworthy bit of the value indicates the number sign and the left behind 39 bits indicate the extent. Negative statistics are represented using two different complement notations.

Some Vital Examples:

In this following example, the IMSUM excel function is being used to determine the sum of several different complex numbers.

The functions are displayed in the worksheet to the left along with the outcomes are revealed in the worksheet that is to the right.

Formulas:                                          Results:

=OCT2BIN (“5”)                               101

=OCT2BIN (“0000000001”)             1

=OCT2BIN (“2″, 10)                          0000000010

=OCT2BIN (“7777777770”)             1111111000

=OCT2BIN (“16”)                             1110

Note:

You have to remember that the above sample spreadsheet, binary numbers and negative octal the in the samples are represented by 2 complement notation.

For more information about OCT2BIN function in Excel, you can visit Microsoft Office site.

Common Errors in Excel OCTO2BIN Function:

In case you get the error from the IMSUB function in excel, it would be possible be any one of these:

  • #NUM! – It happens when supplied NUMBER argument isn’t identified as the complex number
  •    When supplied Place argument is ? 0
  •    resulting binary numbers needs more places than the specified supplied Places argument
  • #VALUE! – It occurs when supplied PLACES arguments isn’t recognized as a number
  • #NAME? – It turns out when the Analysis Tool Pak adds on is not capable in the Excel. You are needed to have allowed the add-on if you like to utilize Excel engineering functions.

For you to do it in Excel version 2003, you have to do the following:

  • From Tools drop down list of options, you have to choose the option Analysis Tool Pak and then click OK.
  • An add-on option will pop out and from here, you need to choose the option Analysis Tool Pal and then click OK.

For you to do it in Excel version 2007, you have to do the following:

  • Click Microsoft button just on top of the left spreadsheet and then choose Excel Option button
  • From Menu, select Add on located at the left side
  • In Manage box, you have to choose Excel Add- In and then click GO
  • An Add-on option will pop out. From here, you have to choose option Analysis Tool Pak and then click OK