How to use Excel FLOOR function

Introduction FLOOR function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given number to the nearest multiple , towards zero. For example, number 1.5 is rounded down by significance 1 to the nearest integer towards zero by formula =FLOOR(1.5,1) which gives 1 as the result. FLOOR function is same as MROUND function except it always rounds down.   Syntax =FLOOR(Number, Significance) Arguments Number- The number or cell containing the number that is to be…

Continue Reading

How to use Excel EVEN function

Introduction EVEN in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to the nearest even integer. For example, number 1.5 is rounded up to the nearest even integer by using the formula =EVEN(1.5) which gives 2 as the result. It can also be used to find the number of items which come in bundles of two’s.  Syntax =EVEN(Number) Arguments Number- The number or cell containing the number that is to be rounded…

Continue Reading

HOW TO USE EXCEL IF FUNCTION

Introduction IF comes in the category of logical functions. IF function can be used for logical comparison of values and to get the first result when the comparison is TRUE and second result when the comparison is FALSE. It is evaluated by putting various logical operators like “=”,”>”,”<” etc. in the formula .IF function is also used in combination with other functions like AND , OR , COUNT etc. More than one function can be tested with the help of…

Continue Reading

How to use Excel FIXED function

Introduction FIXED function in excel is a String/Text function. It is a worksheet function. It rounds the given number to a defined number of decimal places. It changes the format of the number into decimal format by using commas and period. Its result is in form of a text representation of the given number.  For example, number 1.548 is rounded by using the formula =FIXED(1.548,1,TRUE) which gives 1.5 as the result. Syntax =FIXED(Number, Decimals, No_Commas) Arguments Number- The number or…

Continue Reading

How to use Excel ROWS function

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 array – It can be the range of cells or an array formula, or an array.                                                  Keynotes A name range may also be used…

Continue Reading

How to use Excel ROW function

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. Syntax =ROW(Reference) Arguments Reference- It is the reference made to a cell or a range of cells whose row number has to be found. It…

Continue Reading

How to use excel OR Function

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, ...) Arguments value1 – It is the 1st value (logical) that will be processed. value2 -  It is the 2nd value (logical) that will be processed.…

Continue Reading

How to use Excel MONTH function

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 a feeder. Syntax =MONTH( Date ) Arguments Date:- A date in a valid excel format. Can be entered using DATE function, If dates in form…

Continue Reading

How to use Excel INDIRECT function

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 sheet.  Syntax =INDIRECT(ref_text, a1 ) Arguments Refer_text:- It is the reference to a cell as a text string, a name as a reference, A1 style…

Continue Reading

How to use Excel EOMONTH function

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 dates falling on last date of a month. It can also be used with EDATE function. Syntax =EOMONTH( Start_Date, Months ) Arguments Start_Date:- A date…

Continue Reading
Close Menu