Financial: Returns the future value of an initial principal after applying a series of compound interest rates GAMMA (2013) Statistical: Returns the Gamma function value GAMMA.DIST (2010) Statistical: Returns the gamma distribution GAMMADIST Compatibility: Returns the gamma distribution GAMMA.INV ...
/// types in a new formula which contains the RTD function. /// /// /// Required Integer. A unique value, assigned by Microsoft Excel, which identifies the topic. /// Required Object. A single-dimensional array of strings identifying the topic. /// Required Boolean. True to determ...
The LOG10 function returns the base-10 logarithm of a given number.Syntax =LOG10 (number)Arguments Number (required): The positive number that you want to calculate the base-10 logarithm of.Return value The LOG10 function returns a numeric value.Function...
Error if the start_date argument is a non-numeric value, for instance, cell C4 refers to the text “Delivery Date”. Things to Remember A positive number in the months argument returns dates in the future, whereas a negative number yields dates in the past. The EOMONTH function ignores any...
ROUNDUP Function: Syntax & Arguments ⦿Function Objective TheROUNDUP functionrounds a number away from zero. ⦿Syntax ROUNDUP(number, num_digits) ⦿Arguments ⦿Return Value TheROUNDUP functionreturns a rounded number. ⦿Version TheROUNDUP functionhas been introduced in Excel 2003 version and is...
In Excel 2019 and Excel for Office 356, the MAXIFS function can be a solution, provided that your data set contains at least one positive number or zero value: =MAXIFS(A1:B5,A1:B5,">=0") Since the formula searches for the highest value with the condition "greater than or equal to 0...
Therefore, the most common reason in Excel to calculate an absolute value, is toconvert a numberfrom negative to positive within a formula. The Excel ABS Function This is done using theABS function. You can see a simple example of this function used below in column B to return the absolute...
The syntax of the Excel UNIQUE function is as follows: UNIQUE(array, [by_col], [exactly_once]) Where: Array(required) - the range or array from which to return unique values. By_col(optional) - a logical value indicating how to compare data: ...
FunctionCellValue FunctionResult Functions GeometricShape GettingDataErrorCellValue GroupShapeCollection HeaderFooter HeaderFooterGroup Icon IconSetConditionalFormat Identity Image InsertWorksheetOptions IterativeCalculation JavaScriptCustomFunctionReferenceCellValue Line LinkedDataType LinkedDataTypeAddedEventArgs LinkedData...
Map array to custom function array1array2...lambda RANDARRAY Get array of random numbers rowscolumnsminmaxinteger REDUCE Reduce an array initial_valuearraylambda SCAN Scan array and return intermediate results initial_valuearraylambda SEQUENCE