Saurabh Jain
-
Posts
1,726 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
Returns the natural logarithm of a number.
-
Divides two numbers and returns the whole part of the resulting number.
-
Returns the factorial of a number.
-
Returns a number representing e raised to a power.
-
Returns the number of combinations of a given number of items for the optional combination size.
-
Returns the absolute value of a number.
-
Returns the larger integer greater than or equal to a number value.
-
Returns Number.RoundDown(x) when x >= 0 and Number.RoundUp(x) when x < 0.
-
Returns the largest integer less than or equal to a number value.
-
Returns Number.RoundUp(value) when value >= 0 and Number.RoundDown(value) when value < 0.
-
Returns a nullable number (n) if value is an integer.
-
Returns a Single number value from the given value.
-
Returns a percentage value from the given value.
-
Returns a text value from a number value.
-
Returns a number value from a text value.
-
Returns a number value from a value.
-
Returns a 64-bit integer number value from the given value.
-
Returns a 32-bit integer number value from the given value.
-
Returns a 16-bit integer number value from the given value.
-
Returns a signed 8-bit integer number value from the given value.
-
Returns a Double number value from the given value.
-
Returns a decimal number value from the given value.
-
Returns a currency value from the given value.
-
Returns an 8-bit integer number value from the given value.
-
Returns true if a value is an odd number.
