{"id":2262,"date":"2022-08-30T08:03:30","date_gmt":"2022-08-30T08:03:30","guid":{"rendered":"https:\/\/www.overcharts.com\/en\/helpcenter\/?post_type=docs&#038;p=2262"},"modified":"2023-01-20T08:47:32","modified_gmt":"2023-01-20T08:47:32","password":"","slug":"overbasic-math-functions","status":"publish","type":"docs","link":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/","title":{"rendered":"Overbasic &#8211; Math functions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>My.Math<\/strong> category contains all the mathematical (math) built-in functions available in Overbasic.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Abs<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the absolute value of a number\/numeric-expression.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Result type<\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Arguments<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Abs(-2) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 2<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> b <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Abs(10) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 10<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Atan<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the angle in radians of a number\/numeric-expression.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression representing a tangent.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Atan(1) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 0.78539816339745<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Cdeg<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Converts a number\/numeric-expression from radians to degrees.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Cdeg(0.78539816339745) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 45<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Cnum<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the numeric value of a string.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any string.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Cnum(\"2\") <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 2<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Cos<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the cosine of an angle.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression representing an angle in radians.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Cos(3.14159265358979) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: -1<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Crad<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Converts a number\/numeric-expression from degrees to radians.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression representing an angle in degrees.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Crad(45) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 0.78539816339745<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Dec<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the decimal part of a number\/numeric-expression.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Dec(2.5) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 0.5<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Exp<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns <strong>e<\/strong> (a mathematical constant whose value is approximately 2.71828) raised to the specified power. It is the inverse of the <strong>Log<\/strong> function: Eg. Log(10) = 2.30258, Exp(2.30258) = 10<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Exp(2) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 7.38905609893065<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Fix<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the integer part of a number\/numeric-expression. If number is negative, returns the first negative integer greater than or equal to.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Fix(2.5) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 2<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> b <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Fix(-2.7) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: -2<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Int<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the integer part of a number\/numeric-expression. If number is negative, returns the first negative integer lower than or equal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Int(2.5) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 2<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> b <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Int(-2.7) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: -3<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Log<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Calculates the natural logarithm (or of the specified base) of a number\/numeric-expression.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n\n\n\n<li><strong>BASE<\/strong>: (<em>optional<\/em>) is the base of the logarithm. If not specified, it is the base of the natural logarithm (2.71828).<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Log(10) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 2.30258<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> b <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Log(10, 10) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 1<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Mod<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the remainder after dividing two numbers\/numeric-expressions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION1<\/strong>: any numeric expression.<\/li>\n\n\n\n<li><strong>EXPRESSION2<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Mod(5, 4) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 1<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pi<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns PI value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Pi <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 3.14159265358979<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Rnd<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns a random number between 0 and 1.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Rnd<\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Round<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Rounds the decimal part of a number to a specific digit.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong> any numeric expression.<\/li>\n\n\n\n<li><strong>DECIMALS<\/strong>: (<em>optional<\/em>) any numeric expression representing the decimal digit to which to round EXPRESSION. If omitted, EXPRESSION is rounded to the nearest integer.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Round(21.456) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 21<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> b <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Round(21.456, 0) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 21<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> c <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Round(21.456, 1) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 21.5<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> d <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Round(21.456, 2) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 21.46<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Sin<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the sine of an angle.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression representing an angle in radians.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Sin(3.14159265358979) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 0<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Sqr<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the square root of a number\/numeric-expression.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Sqr(4) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 2<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Stdev<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Calculates the standard deviation of a data series considering the last x periods.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DATA<\/strong> any data function (e.g. Open, High, Low, Close, Volume), indicator, array type variable (or function).<\/li>\n\n\n\n<li><strong>PERIODS<\/strong>: number of bars to calculate the standard deviation on.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Stdev(Close, 10)<\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Sum<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Sum EXPRESSION results of last x periods.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong> any numeric expression.<\/li>\n\n\n\n<li><strong>PERIODS<\/strong>: number of bars to calculate Expression on (including current bar).<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Sum Close values of last 10 bars:<\/mark>\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Sum(Close, 10)<\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tan<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the tangent of an angle.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any numeric expression representing an angle in radians.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Tan(3.14159265358979 \/ 4) <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 1<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Val<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns the numeric value of a string.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Result type<\/strong><\/strong>: numeric<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Arguments<\/strong><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>EXPRESSION<\/strong>: any string.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-code\"><code><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">Dim<\/mark><\/strong> a <strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#0088cd\" class=\"has-inline-color\">As Numeric<\/mark><\/strong> = My.Math.Val(\"2\") <mark style=\"background-color:rgba(0, 0, 0, 0);color:#3fad1d\" class=\"has-inline-color\">'Result: 2<\/mark><\/code><\/pre>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>My.Math category contains all the mathematical (math) built-in functions available in Overbasic. Abs Returns the absolute value of a number\/numeric-expression. Result type: numeric Arguments: Atan Returns the angle in radians of a number\/numeric-expression. Result type: numeric Arguments: Cdeg Converts a number\/numeric-expression from radians to degrees. Result type: numeric Arguments: Cnum Returns the numeric value of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[18],"doc_tag":[],"class_list":["post-2262","docs","type-docs","status-publish","hentry","doc_category-built-in-funtions"],"year_month":"2026-10","word_count":738,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Overcharts Team","author_nicename":"overadmin","author_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/author\/overadmin\/"},"doc_category_info":[{"term_name":"Built-In Funtions","term_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs-category\/built-in-funtions\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Overbasic - Math functions - Overcharts Help Center<\/title>\r\n<meta name=\"description\" content=\"My.Math category contains all the mathematical (math) built-in functions available in Overbasic.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Overbasic - Math functions - Overcharts Help Center\" \/>\r\n<meta property=\"og:description\" content=\"My.Math category contains all the mathematical (math) built-in functions available in Overbasic.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Overcharts Help Center\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-01-20T08:47:32+00:00\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-math-functions\\\/\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-math-functions\\\/\",\"name\":\"Overbasic - Math functions - Overcharts Help Center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\"},\"datePublished\":\"2022-08-30T08:03:30+00:00\",\"dateModified\":\"2023-01-20T08:47:32+00:00\",\"description\":\"My.Math category contains all the mathematical (math) built-in functions available in Overbasic.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-math-functions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-math-functions\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-math-functions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Overbasic &#8211; Math functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\",\"name\":\"Overcharts Help Center\",\"description\":\"Trading Software &amp; Technical Analysis\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Overbasic - Math functions - Overcharts Help Center","description":"My.Math category contains all the mathematical (math) built-in functions available in Overbasic.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/","og_locale":"en_US","og_type":"article","og_title":"Overbasic - Math functions - Overcharts Help Center","og_description":"My.Math category contains all the mathematical (math) built-in functions available in Overbasic.","og_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/","og_site_name":"Overcharts Help Center","article_modified_time":"2023-01-20T08:47:32+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/","name":"Overbasic - Math functions - Overcharts Help Center","isPartOf":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website"},"datePublished":"2022-08-30T08:03:30+00:00","dateModified":"2023-01-20T08:47:32+00:00","description":"My.Math category contains all the mathematical (math) built-in functions available in Overbasic.","breadcrumb":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-math-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.overcharts.com\/en\/helpcenter\/"},{"@type":"ListItem","position":2,"name":"Overbasic &#8211; Math functions"}]},{"@type":"WebSite","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/","name":"Overcharts Help Center","description":"Trading Software &amp; Technical Analysis","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.overcharts.com\/en\/helpcenter\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/comments?post=2262"}],"version-history":[{"count":12,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2262\/revisions"}],"predecessor-version":[{"id":2274,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2262\/revisions\/2274"}],"wp:attachment":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/media?parent=2262"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_category?post=2262"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_tag?post=2262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}