IMARGUMENT Excel Formula

Microsoft Excel is considered as a multifaceted software program that is extremely used in any office or accounting works. For over twenty years, Excel has spread its excellence and most of the business people use it. Most of them took for granted the widespread use of Excel and even the long-time accounting users never know how to handle small fraction.

Microsoft Excel is an electronic spreadsheet and software program used to organize, manipulate, calculate and store data. It performs mathematical basic operations as summing up rows and columns of figures. It aims to find values such as loss or profits. It calculates plan for loans or mortgages repayment. It aims to search for the minimum, average and maximum values in a date with specified range. It used to chart or graph data assisting the users to identify the figures. It filters and sorts data finding the specific and detailed information.

There are several hidden treasures in Microsoft Excel that most users are not aware of, which includes the formulas and functions. Excel has functions of less than 331 although most of them are utilized by engineers who in a way involved in high math level or statistics. Function is somewhat complex formulas that happened covertly. The user must need to memorize the function’s name and must know the proper use of it. The use of functions always bears to type the parenthesis sets and function names. Parenthesis holds single or either cell addresses.

Formulas are the combination of the operator of cell addresses and functions. Formulas are needed to merge multiple functions or if there are no existing definite functions of what the user needs. Using both functions and formulas properly begin with a =, which is the technical reminder.

Microsoft Excel has many different functions and formulas, which are often used with various usages. One of the functions is the IMARGUMENT. IMARGUMENT function in Microsoft Excel uses returns of the argument of an angle, which convey a radian to its supplied complex digit or number. The IMARGUMENT function syntax is IMARGUMENT(inumber). iNumber is considered the complex number.

Common Errors of the IMARGUMENT Function in Microsoft Excel:

  • #NUM! – occurs when the supplied iNumber is not being recognized as the complex number.
  • #NAME! – occurs when the analysis toolPak add-in is disabled in your Microsoft Excel. This is to remind you that you have to enable the Excel’s engineering functions

Here’s how it works with Excel 2003:

  • From its droop down tool menu, select the Add-ins options.
  • Once the add-in pops up, choose the analysis toolpak option then click OK.

For the Excel 2007 and Excel 2010

  • Hit the Microsoft button over the left of the spreadsheet and choose the “Excel Button” option.
  • On your left side hand, choose the Add-ins
  • Select the Excel Add-ins inside the manage box then hit Go.
  • Once it pops up choose the analysis toolpak option then hit the button OK.

Remarks:

Post comment