You can use the asterisk symbol (*) to multiply either formulas, cells or values in Excel. Multiplication can be applied many times until you get the result. An alternative is to use the PRODUCT() function. An example is =PRODUCT(A1:A4) This will multiply all the...
Office 365 Excel Roundup function allows you to round a number to the nearest whole number or nearest 10s or 100s. Below are detailed examples of Roundup() function plus instructions on rounding up to nearest multiples. Syntax ROUNDUP (number, num_digits) number: the...
COUNTIF() in Excel counts the number of cells matching a criteria. You can use it to find cells that equal to certain text, date or values. Like SUMIF(), COUNTIF() function allows wildcard characters (? and *). Countif Function in Excel COUNTIF() function has the...
SUMIF() function sums up a numerical range given criteria from another range of equal dimension. The criteria can test whether the range equals to a certain text string, greater or smaller than a number, between certain dates etc. You can also use wildcards for fuzzy...
CONVERT() function is a unit-conversion function primarily used to convert units between different measurement systems. It is one of the less well-known functions that deserves more popularity. The function can come in handy when you do not know the exact formula for...
Description AND function allow you to specify the conditions that must all be true. Syntax AND(condition1, [condition2],…) condition1: Required. A logical test that gives TRUE or FALSE. condition2: Optional. You can have up to a maximum of 255 arguments. Text...
Description The function checks the sign of a number and returns either 1, 0 or -1. Syntax SIGN(number) number: Required, a real number (as opposed to imaginary number in mathematical terms) you want to check the sign for. Usage Sign function is a handy function to...
Description Returns the accrued interest for a security with maturity interest payment only. Syntax ACCRINTM(issue, settlement, rate, par, [basis]) Issue Required. This is the issue date of the security.Settlement Required. This is when the security will settle and...
Description ACCRINT returns the accumulated interest for an regular interest paying security. Syntax ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) Issue Required. The date when security was issued.First_interest Required. The...
Syntax ABS(number) Usage ABS() function is used to get the value of a number without the sign. In mathematical term, absolute value. Example FormulaResult=ABS(-10)10=ABS(4)4