Cube: Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. CUBERANKEDMEMBER Cube: Returns the nth,
Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. =NPV(0.05, A1:A10) IRR Calculates the internal rate of return for a series of cash flows. =IRR(A1:A10) RATE Returns the interest rate per period of an annuity. =RATE(10, ...
Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set. SqrtPi Returns the square root of (number * pi). Standardize Returns a normalized value from a distribution characterized by mean and standard_dev. StDev Esti...
For ex., I would like set up a formula/macro such that the output field to auto-populate based on the following criteria: 1) the smallest number in the input filed gets the biggest value, i.e. 9; the next smallest gets 7, and so on in decrements of 2; 2) if ...
You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score. Lcm Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a ...
Return Value Double Remarks If array is empty, LARGE returns the #NUM! error value. If k ≤ 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value. If n is the number of data points in a range, then LARGE(array,1) returns the largest value, ...
Return value Double Remarks If array is empty,Smallreturns the #NUM! error value. If k ≤ 0 or if k exceeds the number of data points,Smallreturns the #NUM! error value. If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equa...
If lookup_value is smaller than the smallest value in the first row of table_array, HLOOKUP returns the #N/A error value. Example The example may be easier to understand if you copy it to a blank worksheet. Create a blank workbook or worksheet. ...
array: This parameter specifies the cell range where the function will look for the value parameter. Ensure that the array parameter can be found within the first column of the array for the formula to work correctly. index: This argument defines the column number that contains the return val...
{"__typename":"ForumTopicMessage","uid":16024,"subject":"Find the smallest value other than zero","id":"message:16024","revisionNum":4,"repliesCount":8,"author":{"__ref":"User:user:14969"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"...