18Nov2014

INDIRECT function in Excel: How to dynamically refer multiple sheets?

INDIRECT function in Excel returns the reference specified by a text string. The syntax for this excel function is as follows. Formula Syntax: INDIRECT( ref_text, [a1] ) ref_text can be the range of cells or a named range. [a1] can be TRUE or FALSE. TRUE is used to indicate that ref_text is in R1C1 style
  • 18 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, indirect function in excel,
Read more
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
  • 1 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • accrint, accrued interest,
Read more
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
  • 1 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • dget, multiple lookup,
Read 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.
  • 29 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • dmax, dmin,
Read more
<< Newer Posts