sqrt, cbrt
Function sqrt:If the input value is a positive number, then the square root will be calculated. If negative, a void value will be returned.
Function cbrt:Calculates the cube root
Non-numeric values (including dates) are passed through without modifications. This is particularly suitable in combination with vectorization in order
to pass through blank contents, explanatory text, etc.
Vectorization: This function supports vectorization in the 1st function parameter.
Instead of providing a single value, you can provide a set or even a nested set which contain multiple values.
The function will then process every value and its return value contains a corresponding set containing all results.
Indirect parameter passing is disabled
Vectorization is allowed in the 1st function parameter
1
No. | Type | Description |
---|---|---|
1 input |
all types set |
Value Value or set containing multiple values (vectorization) |
Type | Description |
---|---|
all types set |
Result Calculated value(s) |
echo( sqrt( 4 ) );
echo( sqrt( 2 ) );
echo( sqrt( {1,4,9,16,25} ) ); // Vectorization
echo( sqrt( {"", "Text", 2, -2, date(today)} ) ); // Vectorization, non-numeric values will bypass
2
1.4142135624
{1,2,3,4,5}
{'','Text',1.4142135624,# Negative Square Root #,'2024-10-19'}
Power Functions