Find Nearest Multiple in Excel This example illustrates three functions to round numbers to a multiple of x in Excel. The MROUND, CEILING and the FLOOR function. Mround 1. For example, round a number to the nearest multiple of 10. 2. For example, round a number to the nearest multiple of 5. Ceiling The same as MROUND but rounds up. Floor The same as …
What is COSH function in Excel? COSH function is one of the Maths and Trig functions in Microsoft Excel that returns the hyperbolic cosine of a number. Syntax of COSH function COSH(number) The COSH function syntax has the following arguments: Number: Any real number for which you want to find the hyperbolic cosine. COSH formula explanation …
This Excel tutorial explains how to use the INDIRECT function with syntax and examples. Excel INDIRECT function Description Microsoft Excel INDIRECT function returns the reference to a cell based on its string representation. The INDIRECT function is a built-in function in Excel that is categorized as a Lookup/Reference Function that can be entered as part of a formula in a …
This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3, but you can do this for any number. 1. The ROW function returns the row number of a cell. 2. The MOD function gives the remainder of a division. For …
This example shows the difference between the SUBSTITUTE function and the REPLACE function. 1a. If you know the text to be replaced, use the SUBSTITUTE function. 1b. The SUBSTITUTE function has a 4th optional argument. You can use this argument to indicate which occurrence you want to substitute. 2. If you know the position of the text to …
This Excel tutorial explains how to use the NOT function with syntax and examples. Excel NOT Function Description The Excel NOT function returns the opposite to a supplied logical value. That is, If supplied with the value TRUE, the Not function returns FALSE; If supplied with the value FALSE, the Not function returns TRUE. Excel …
This example illustrates the EVEN and the ODD function in Excel. It also shows you how to determine if a number is even or odd. Even 1. Rounds a positive number up to the nearest even integer. 2. Rounds a negative number down to the nearest even integer. Odd 1. Rounds a positive number up to the nearest odd integer. …
What is COT function in Excel? COT function is one of the Math and Trig functions in Microsoft Excel that return the cotangent of an angle specified in radians. Syntax of COT function COT(number) The COT function syntax has the following arguments. Number: The angle in radians for which you want the cotangent. COT formula explantion …
This Excel tutorial explains how to use the LOOKUP function with syntax and examples. Excel LOOKUP function Description The Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array. The LOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used …
LARGE function example shows you how to create an array formula that sums the largest numbers in a range. Syntax: LARGE(array, k) Returns the k-th largest value in a data set. You can use LARGE to return the highest, runner-up, or third-place score. For example, 1. Find the second to largest number, use the following function. 2. To sum …
Locate Maximum Value in Excel This example teaches you how to find the cell address of the maximum value in a column. 1. First, we use the MAX function to find the maximum value in column A. 2. Second, we use the MATCH function to find the row number of the maximum value. Explanation: the MATCH function reduces to …
This Excel tutorial explains how to use the TRUE function with syntax and examples. Excel TRUE Function Description The Excel True function returns the logical value TRUE. The function takes no arguments and therefore, the syntax is simply: TRUE() Note that you can also get the same result by simply typing the text ‘True’ into …
What is COTH function in Excel? COTH function is one of the Math and Trig functions in Microsoft Excel that return the hyperbolic cotangent of a hyperbolic angle. Syntax of COTH function COTH(number) The COTH function syntax has the following arguments. Number COTH formula explanation The hyperbolic cotangent is an analog of the ordinary (circular) cotangent. …
This Excel tutorial explains how to use the MMULT function with syntax and examples. Excel MMULT function Description Excel MMULT function returns the matrix product of two arrays. The array result contains the same number of rows as array1 and the same number of columns as array2. If returning multiple results in an array on the worksheet, enter as an …
This page provides a complete Excel Functions list, grouped by category. Each of the function links will take you to a dedicated page, where you will find a description of the function, with examples of use and details of common errors. Text Functions Logical Functions Information Functions Date and Time Functions Lookup and Reference Functions …
To get the number of days, weeks or years between two dates in Excel, use the DATEDIF function. The DATEDIF function has three arguments. 1. Fill in “d” for the third argument to get the number of days between two dates. Note: =A2-A1 produces the exact same result! 2. Fill in “m” for the third argument to …
This Excel tutorial explains how to use the XOR function with syntax and examples. Excel XOR Function Function Description Excel XOR function performs what is called “exclusive OR”. The XOR function returns the Exclusive Or logical operation for one or more supplied conditions. With two logical statements, XOR returns TRUE if either statement is TRUE, but returns …
What is CSC function in Excel? CSC function is one of the Math and Trig functions in Microsoft Excel that returns the cosecant of an angle specified in radians. Syntax of CSC function CSC(number) The CSC function syntax has the following arguments. Number CSC formula explanation The absolute value of Number must be less than 2^27. …
This Excel tutorial explains how to use the MATCH function with syntax and examples. Excel MATCH function Description MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. Often, the INDEX function is combined with MATCH to retrieve …
Excel has many functions to offer when it comes to manipulating text strings. The Excel TEXT function returns a number in a specified number format, as text. You can use the TEXT function to embed formatted numbers inside text. Here’s a full list of Built-In Text Functions in Excel and their Descriptions below: Click each of the function link to see detailed example. …
An easy formula that returns the quarter for a given date. There’s no built-in function in Excel that can do this. 1. Enter the formula shown below. Explanation: ROUNDUP(x,0) always rounds x up to the nearest integer. The MONTH function returns the month number of a date. In this example, the formula reduces to =ROUNDUP(5/3,0), =ROUNDUP(1.666667,0), 2. May is …
This Excel tutorial explains how to use the AND function with syntax and examples. Excel AND Function Description Microsoft Excel AND function tests a number of supplied conditions and returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE. That is; TRUE if ALL of the conditions evaluate to TRUE or FALSE otherwise …
What is CSCH function in Excel? CSCH function is one of the Math and Trig functions in Microsoft Excel that return the hyperbolic cosecant of an angle specified in radians. Syntax of CSCH function CSCH(number) The CSCH function syntax has the following arguments. Number CSCH formula explanation The absolute value of Number must be less than …
This Excel tutorial explains how to use the OFFSET function with syntax and examples. Excel OFFSET function Description The Microsoft Excel OFFSET function returns a reference to a range that is offset a number of rows and columns from another range or cell. OFFSET function is a built-in function in Excel that is categorized as a Lookup/Reference …
Logic Functions in Excel check the data and return the result «TRUE» if the condition is true, and «FALSE» if not. Here’s a full list of Built-In Logical Functions in Excel and their Descriptions below: Click each of the function link to see detailed example. Boolean Operator Functions AND Tests a number of user-defined conditions and …
Excel has many functions to offer when it comes to manipulating text strings. Formula tab → Function Library Group → Text Function N/B: Every formula in excel must begin with an equal sign, function then in bracket; cell name/cell ranges/cell references. Syntax: =fx(cell name/cell ranges/cell references) Example: = Sum( A1:B4) Where Sum is the function name and A1:B4 is …
An easy formula that returns the day of the year for a given date. There’s no built-in function in Excel that can do this. 1. To get the year of a date, use the YEAR function. 2. Use the DATE function below to return January 1, 2016. The DATE function accepts three arguments: year, month and day. 3. The …
This Excel tutorial explains how to use the OR function with syntax and examples. Excel OR Function Description The Excel OR function tests a number of supplied conditions and returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE. That is; TRUE if ANY of the conditions evaluate to TRUE or FALSE otherwise (i.e. if ALL of the conditions …
What is DECIMAL function in Excel? DECIMAL function is one of the Math and Trig functions in Microsoft Excel that converts a text representation of a number in a given base into a decimal number. Syntax of DECIMAL function DECIMAL(text, radix) The DECIMAL function syntax has the following arguments. Text: Radix: Radix must be an integer. …
This Excel tutorial explains how to use the ROW function with syntax and examples. Excel ROW Function Description Microsoft Excel ROW function returns the row number of a cell reference. The ROW function is a built-in function in Excel that is categorized as a Lookup/Reference Function. The ROW function can be entered as part of a formula …
Before using the Date and Time Excel Functions, it is advised that you ensure you have a clear understanding of the way Excel stores Dates and Times Here’s a full list of Built-In Date and Time Excel Functions in Excel and their Descriptions below: Click each of the function link to see detailed example. Creating Dates …
This example teaches you how to get the date of a holiday for any year (2019, 2020, etc). Before you start: the CHOOSE function returns a value from a list of values, based on a position number. For example, =CHOOSE(3,”Car”,”Train”,”Boat”,”Plane”) returns Boat. The WEEKDAY function returns a number from 1 (Sunday) to 7 (Saturday) representing the day of the week of …
What is ATAN function in Excel? ATAN function is one of the Math and Trig functions in Microsoft Excel that returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2. Syntax of ATAN function ATAN(number) The …
COUNTIF is one of the statistical functions, it is used to count the number of cells that meet a criterion This chapter covers many easy to follow COUNTIF examples like Numbers, Text, Booleans, Errors and ‘Or Criteria’. Numbers 1. The COUNTIF function below counts the number of cells that contain the value 20. 2. The following COUNTIF …
This Excel tutorial explains how to use the ROWS function with syntax and examples. Excel ROWS Function Description The Microsoft Excel ROWS function returns the number of rows in a cell reference. The ROWS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. The ROWS function can be entered as part of a …
Information Functions is a built-in function in Excel that returns info about the current environment, including platform. The Information Functions can be used as a worksheet function in Excel. As a worksheet function, the INFO function can be entered as part of a formula in a cell of a worksheet. Here’s a full list of …
This example illustrates how to concatenate (join) strings in Excel. When joining text and a number, use the TEXT function to format that number. 1. Simply use the & operator to join strings. Note: to insert a space, use ” ” 2. The CONCATENATE function produces the exact same result. 3a. The CONCAT function in Excel 2016 produces the exact …
To enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function. To enter the current date and time as a static value, use keyboard shortcuts. Today and Now 1. To enter today’s date in Excel, use the TODAY function. Note: the TODAY function takes no arguments. This date will …
IF function and ISERROR function are used to check for an error in Excel. This example shows you how to create an array formula that counts the number of errors in a range. 1. We use the IF function and the ISERROR function to check for an error in the record below: Explanation: the IF function returns 1, if an …
What is Standard Deviation (STDEV.P, STDEV.S)? This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel. What is Standard Deviation? Standard deviation is a number that tells you how far numbers are …