Introduction ROWS function in excel is a lookup or reference function. It provides us with number of rows in an array or reference. We have to enter a range in Excel format and it returns number of rows present in that range. For example row A1:A6 gives 6 as the result. Syntax =ROWS(Array) Arguments … Read more
Introduction ROW function in excel is a reference function. It returns the row number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =ROW(A9) returns 9 as A9 is the 9th row in Excel. … Read more
Introduction The OR Function is used as a logical function to check multiple conditions at the same instant. OR provides value in the form of TRUE or FALSE. OR function can be used with IF function to remove complexity of multiple nested IF’s and is also used with function AND. Syntax =OR (value1, value2, …) … Read more
Introduction MONTH function in Excel is a type of DATE/TIME function. It used to obtain find month of a specified date. It returns a serial number in integer form (1 for Jan. up to 12 for Dec). It can be used to supply month into a cell or used with functions like DATE function as … Read more
Introduction INDIRECT function in excel is a reference function. It is used to change a text string to a valid reference in formula. It can be used when a reference in form of text need to be changed into a valid reference. This reference does not change when rows and columns are added into the … Read more
Introduction EOMONTH function in Excel is a type of DATE/TIME function. It used to obtain last date of a month. This date can be of the present month or a month in past and future. It returns a serial number which can be formatted into a readable form. It can be used to calculate due … Read more
Introduction HLOOKUP function in excel is a lookup function. This function is used to return data from a row in a table. Here ‘H’ stands for horizontal as the function moves horizontally to right in a row to lookup a value. It is used in three ways- Exact value, approximate value, Wildcard value. It is … Read more
Introduction INDEX function in excel is a lookup or reference function. It is used to return reference or value from a table or array to another location. It uses both row and column position to retrieve the value. It can return a row, column or a single cell. It is often used in combination with … Read more
Introduction EDATE function in Excel is a type of DATE/TIME function. It used to obtain a date in future and past on the exact same day of a specified date. It returns a serial number which provides a date which is after or before the specified date. It is used to find expiry dates and … Read more
Introduction DAY function in Excel is a type of DATE/TIME function. It gives value of the day of month numbering between 1 and 31. This function can be applied to find the number of the day from the date present in the cell. This can also be used to extract and put the number of … Read more