Excel for Commerce | Blog | Page 4

01Oct2014: How to calculate accrued interest using Microsoft Excel?

ACCRINT

To calculate accrued interest, Excel has a function called ACCRINT. Using this function, we can calculate accrued interest for a security paying periodic interest. Go ahead and read through to know how and when the function can be used.

ACCRINT function in Excel returns the accrued interest for a security that pays interest on a periodic basis. To calculate accrued interest, first let us know the syntax of the ACCRINT function

Syntax of ACCRINT function is =ACCRINT(issue date, first interest date,…

01Oct2014: How to lookup a value with multiple criteria in a table?

Ever wondered how to lookup multiple criteria in excel? We will tell how you can do that. Excel provides a function called DGET which lets you to lookup multiple criteria. Let us know more about DGET.

DGET

DGET function in Microsoft Excel extracts a single value from a column of a list or a database that matches the conditions specified by us.

Syntax for this excel function is =DGET(database, field, criteria)

30Sep2014: SUMIF and SUMIFS

SUMIF:

SUMIF function in Microsoft Excel, adds the cells specified by a criteria.

Syntax for this excel function =Sumif(range, criteria, sum range)

Sumif formula can be used in Microsoft Excel to add all values against a single criteria.

Let’s take an example, here we have a data table of Sales persons and their sales numbers. We are interested in finding the total sum of sales for a sales person named ‘Paul’. We…

29Sep2014: COUNTIF and COUNTIFS

COUNTIF:

The COUNTIF function in Microsoft Excel counts the number of cells within a range that meet a single criterion that you specify. For example, let’s create a table of Employees and their work hours. We are interested in finding the number of employees who work more than eight hours, this can be easily done by COUNTIF function in Excel.

(more…)

29Sep2014: DMIN and DMAX

DMIN and DMAX functions fall under Database functions in Microsoft Excel. These Excel functions are used to find specific information based on given criteria.

(more…)

29Sep2014: Enable Macros for Excel VBA Files

Macros in Microsoft Excel should be enabled to run Excel file with macros. Following blog will help us in understanding how to do it.

Let’s open the Microsoft Excel File which contains Macros (they are also called as VBA code). When this type of file is opened, Excel pops up a warning notification as “Protected View Be careful – Files from internet may contain viruses. Unless you need to edit it, it’s safer to stay in protected view”

We need to…

ACCRINT