Help:Calculation

{{h:h|editor toc}}

:''The accuracy and format of numeric results varies with the server, even on a single Wikimedia page.''

The MediaWiki extension [[mw:Extension:ParserFunctions|ParserFunctions]] enables users to perform mathematical computations.

The <tt>expr</tt> function evaluates numerical expressions, and also boolean expressions involving numbers and booleans (not strings). The syntax is

:<nowiki>{{</nowiki> #expr: ''expression'' }}

The spaces are not needed. Inside numbers no spaces are allowed.

The supported operators (roughly in order of precedence) are
'''<tt>not</tt>''',
'''<tt>*</tt>''', '''<tt>/</tt>''', '''<tt>div</tt>''', '''<tt>mod</tt>''',
'''<tt>+</tt>''', '''<tt>-</tt>''', 
'''<tt>round</tt>''', 
'''<tt>=</tt>''', '''<tt>&lt;&gt;</tt>''', '''<tt>!=</tt>''', '''<tt>&lt;=</tt>''', '''<tt>&gt;=</tt>''',
'''<tt>and</tt>''', and
'''<tt>or</tt>'''.

== Operators ==
Returns 0 or 1 for Booleans or true/false.

{| cellpadding="6px" border=1 style="border:1px solid #C0C0C0; border-collapse:collapse;"
! ''Operator''
! ''Operation''
! ''Examples''
|-
| none|| none
|
{| class="wikitable"
|{{xpd0|#expr:123456789012345|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:1.23456789012345|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:.000001|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:.00000123456789012345|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:.123e4|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:123E-2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:e|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:pi|gives={{!}}{{!}}}}
|}

Wrong:
{| class="wikitable"
|{{xpd0|#expr:e4|gives={{!}}{{!}}}}
|}
|-
! exp
| Exponential function e<sup>x</sup>
|
{| class="wikitable"
|{{xpd0|#expr:exp1.2|gives={{!}}{{!}}}}
|}

Compare:
{| class="wikitable"
|{{xpd0|#expr:e^1.2|gives={{!}}{{!}}}}
|}
|-
! ln
| Natural logarithm
|
{| class="wikitable"
|{{xpd0|#expr:ln2|gives={{!}}{{!}}}}
|}
Hence, the common logarithm of e.g. 2:
{| class="wikitable"
|{{xpd0|#expr:ln2/ln10|gives={{!}}{{!}}}}
|}
|-
! abs
| Absolute value
|
{| class="wikitable"
|{{xpd0|#expr:abs-1.2|gives={{!}}{{!}}}}
|}
|-
! trunc
| Truncation
|
{| class="wikitable"
|{{xpd0|#expr:trunc1.2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:trunc1.8|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:trunc-1.2|gives={{!}}{{!}}}}
|}
|-
! floor
| Floor function
|
{| class="wikitable"
|{{xpd0|#expr:floor1.2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:floor-1.2|gives={{!}}{{!}}}}
|}
|-
! ceil
| Ceiling function
|
{| class="wikitable"
|{{xpd0|#expr:ceil1.2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:ceil-1.2|gives={{!}}{{!}}}}
|}
|-
! sin
| Sine function
|
{| class="wikitable"
|{{xpd0|#expr:sin.1|gives={{!}}{{!}}}}
|}
With an angle in degrees, e.g. 30°:
{| class="wikitable"
|{{xpd0|#expr:sin(30*pi/180)|gives={{!}}{{!}}}}
|}
|-
! cos
| Cosine function
|
{| class="wikitable"
|{{xpd0|#expr:cos.1|gives={{!}}{{!}}}}
|}
|-
! tan
| Tangent function
|
{| class="wikitable"
|{{xpd0|#expr:tan.1|gives={{!}}{{!}}}}
|}
|-
! asin
| Arc sine function
|
{| class="wikitable"
|{{xpd0|#expr:asin.1|gives={{!}}{{!}}}}
|}
|-
! acos
| Arc cosine function
|
{| class="wikitable"
|{{xpd0|#expr:acos.1|gives={{!}}{{!}}}}
|}
|-
! atan
| Arc tangent function
|
{| class="wikitable"
|{{xpd0|#expr:atan.1|gives={{!}}{{!}}}}
|}
|-
! +
| Unary '''<tt>+</tt>''' sign 
|
{| class="wikitable"
|{{xpd0|#expr:+12|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:++12|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:+-12|gives={{!}}{{!}}}}
|}
|-
! -
| Unary '''<tt>-</tt>''' sign (negation)
|
{| class="wikitable"
|{{xpd0|#expr:-12|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-+12|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:--12|gives={{!}}{{!}}}}
|}
|-
! not
| Unary NOT, logical NOT
|
{| class="wikitable"
|{{xpd0|#expr:not 0|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:not 1|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:not 2|gives={{!}}{{!}}}}
|}
|-
! ^
| Power
|
{| class="wikitable"
|{{xpd0|#expr:2^7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:2^-7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:(-2)^7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:(-2)^8|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:2^1.2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:2^.5|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:(-2)^1.2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:(-2)^.5|gives={{!}}{{!}}}}
|}
|-
! *
| Multiplication
|
{| class="wikitable"
|{{xpd0|#expr:30*7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:30*-7|gives={{!}}{{!}}}}
|}
|-
! /
|| Division, same as '''div'''
|
{| class="wikitable"
|{{xpd0|#expr:30/7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:30/-7|gives={{!}}{{!}}}}
|}
|-
! [[w:en:Division_%28mathematics%29#Division_of_integers|div]]
|| Division, same as '''/''',<br />not integer division
|
{| class="wikitable"
|{{xpd0|#expr:30 div 7|gives={{!}}{{!}}}} (should be 4)
|}
|-
! [[w:en:Modulo operation|mod]]
|"Modulo",&#160;remainder&#160;of&#160;division after truncating both operands to an integer (PHP operator [http://www.php.net/manual/en/language.operators.arithmetic.php %]).<br /><br />Caveat, '''div''' and '''mod''' are different from all programming languages. This has been fixed (but needs to be committed), see [[bugzilla:6068]]. 
|
{| class="wikitable"
|{{xpd0|#expr:30 mod 7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:30 mod -7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-30 mod 7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-30 mod -7|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-8 mod -3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-8 mod 2.9|gives={{!}}{{!}}}} (should be 2.6)
|-
|{{xpd0|#expr:-8 mod 3.2|gives={{!}}{{!}}}} (should be 1.6)
|-
|{{xpd0|#expr:8.9 mod 3|gives={{!}}{{!}}}} (should be 2.9)
|}
|-
! <tt>+</tt>
|| Addition
|
{| class="wikitable"
|{{xpd0|#expr:30 + 7|gives={{!}}{{!}}}}
|}
|-
! <tt>-</tt>
|| Subtraction
|
{| class="wikitable"
|{{xpd0|#expr:30 - 7|gives={{!}}{{!}}}}
|}
|-
! round
|| Rounds off the number on the left to the power of 1/10 given on the right (PHP function [http://www.php.net/manual/en/function.round.php round])
|
{| class="wikitable"
|{{xpd0|#expr:4.2857 round 3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:4.2857 round 0|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:42857 round -2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:4.5 round 0|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-4.5 round 0|gives={{!}}{{!}}}}
|}
|-
! =
|| Equality (numerical incl. logical)
|
{| class="wikitable"
|{{xpd0|#expr:3{{=}}03.0|gives={{!}}{{!}}}}
|}
|-
! &lt;&gt;
| Inequality, same as '''!='''
|
{| class="wikitable"
|{{xpd0|#expr:3<>03.0|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3<>4|gives={{!}}{{!}}}}
|}
|-
!| !=
|| Inequality, same as '''&lt;&gt;''', logical ''xor''
|
{| class="wikitable"
|{{xpd0|#expr:3!{{=}}03.0|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3!{{=}}4|gives={{!}}{{!}}}}
|}
|-
! &lt;
|| Less than
|
{| class="wikitable"
|{{xpd0|#expr:3<2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3<3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3<4|gives={{!}}{{!}}}}
|}
|-
! &gt;
|| Greater than
|
{| class="wikitable"
|{{xpd0|#expr:3>2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3>3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3>4|gives={{!}}{{!}}}}
|}
|-
! &lt;=
| Less than or equal to
|
{| class="wikitable"
|{{xpd0|#expr:3<{{=}}2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3<{{=}}3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3<{{=}}4|gives={{!}}{{!}}}}
|}
|-
! &gt;=
| Greater than or equal to
|
{| class="wikitable"
|{{xpd0|#expr:3>{{=}}2|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3>{{=}}3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:3>{{=}}4|gives={{!}}{{!}}}}
|}
|-
! and
| Logical AND
|
{| class="wikitable"
|{{xpd0|#expr:3 and 4|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:0 and 3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-3 and 0|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:0 and 0|gives={{!}}{{!}}}}
|}
|-
! or
| Logical OR
|
{| class="wikitable"
|{{xpd0|#expr:3 or 4|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:0 or 3|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:-3 or 0|gives={{!}}{{!}}}}
|-
|{{xpd0|#expr:0 or 0|gives={{!}}{{!}}}}
|}
|}

The boolean operators consider 0 to be false and any other number to be true. An intermediate or final result "true" is identified with 1. Thus {{xpd0|#expr: (2 < 3) + 1}}. Note that "and" and "or" work with #expr and #ifexpr only; for use with #if, #ifeq, and #ifexist, use 1 as then-text and 0 as else-text, and combine results with "and" and "or" in an outer #expr or #ifexpr. Instead of <nowiki>{{ #expr: {{#if:{{{a}}}|1|0}} or {{#if:{{{b}}}|1|0}} }} we can also use {{#if:{{{a}}}{{{b}}}|1|0}}}}</nowiki>. For negation, simply subtract from 1 or interchange then- and else-part.

Precedence:
*{{xpd0|#expr: 2 - 3 + 4 / 5 * 6}}

(+ and - have equal precedence, * and / also, both higher than the former two).

*{{xpd0|1=#expr: 2 = 5 < 3 + 4}}

(first +, then =, then <).

*{{xpd0|#expr:1.234 + 1.234 round 1 + 1 }}

(first additions, then round)

*{{xpd0|#expr:3 * 4 mod 10 * 10 }}

(mod and multiplication have equal precedence, evaluation from left to right)

Parentheses can force a different precedence: {{xpd0|#expr: (2 + 3) * 4}}

Blank spaces are good for readability but not needed for working properly, except between not and an adjacent and/div/mod/not/or/round operator, and within numbers not allowed:
*{{xpd0|#expr:7mod3}}
*{{xpd0|#expr:7.5round0}}
*{{xpd0|#expr:0and1}}
*{{xpd0|#expr:0or not0}}
*{{xpd0|#expr:0ornot0}}
*{{xpd0|#expr:123 456}}
*{{xpd0|#expr:not not3}}
*{{xpd0|#expr:notnot3}}

*{{xpd0|#expr:---2}}
*{{xpd0|#expr:-+-2}}
*{{xpd0|#expr:2*-3}}
*{{xpd0|#expr:-not-not-not0}}
*{{xpd0|#expr:2*/3}}
*{{xpd0|#expr:sinln1.1}}
*{{xpd0|#expr:sin ln1.1}}

==Numbers as input==
Leading zeros are allowed, as well as a trailing decimal point (for an integer) and trailing zeros in a number with a decimal point.

*{{xpd0|#expr: +01.20}}
*{{xpd0|#expr: 12.}}

These equivalences are also relevant for #ifeq and #switch, see below.

In [http://svn.wikimedia.org/doc/Expr_8php-source.html] we have 
 define( 'EXPR_NUMBER_CLASS', '0123456789.' );
 ...
 elseif ( false !== strpos( EXPR_NUMBER_CLASS, $char ) ) { 
 // Number
 if ( $expecting != 'expression' ) {throw new ExprError('unexpected_number');}
 // Find the rest of it
 $length = strspn( $expr, EXPR_NUMBER_CLASS, $p );
 // Convert it to float, silently removing double decimal points
 $operands[] = floatval( substr( $expr, $p, $length ) );
 $p += $length;$expecting = 'operator';continue;}

Thus the part of the expression representing a number is a sequence of digits and points; due to [http://www.php.net/manual/en/function.floatval.php floatval] a second point and any digits and points immediately after it are ignored, and do not give an error message. '''Group separators are not allowed''': a comma is considered an unrecognised punctuation character:

Thus a number can only consist of:
* one or more digits, or
* zero or more digits, a point, and zero or more digits.
optionally followed by an power of 10 multiplier : the letter ''E'' (or ''e''), an optional sign and digits (for the base-10 exponent).

For the purpose of evaluating an expression a leading plus or minus sign is considered a unary operator instead of part of the number. The letter ''e'' or ''E'' was initially parsed only as if it was a binary operator, but now when it true only when it follows a number (otherwise this is Euler's constant, i.e. the base of natural logarithms).

Canonical form:
*{{xpd0|#expr: 123}}
*{{xpd0|#expr: 123.456}}
*{{xpd0|#expr: 0.456}}
*{{xpd0|#expr: 0}}
*{{xpd0|#expr: 2.0E-5}}

Accepted, although in some cases more or less odd:
*{{xpd0|#expr: .456}}
*{{xpd0|#expr: 123.}}
*{{xpd0|#expr: 000123}}
*{{xpd0|#expr: 123.456.789}}
*{{xpd0|#expr: .}}
*{{xpd0|#expr: 2e-5}}
*{{xpd0|#expr: 2E-5}}
*{{xpd0|#expr: 1e-5}}
*{{xpd0|#expr: 1 e -5}}

Using Euler's constant ''e'':
*{{xpd0|#expr: E}}
*{{xpd0|#expr: e}}
*{{xpd0|#expr: E-5}}
*{{xpd0|#expr: e-5}}

Wrong:
*{{xpd0|#expr: 123,456}}
*{{xpd0|#expr: 123 456}}

Due to the specifier R ("raw"), {{xpdoc|NUMBEROFARTICLES:R}} etc., i.e. numbers without group separators, which can be used in computations.

As opposed to ParserFunctions, "{{ml|Help:Magic_words|Language-dependent_word_conversions|plural}}" accepts points ''and'' commas in numbers and interprets them in a site-language-specific way (depending on $separatorTransformTable in Messagesxx.php); on this site:
*{{xpd5op3p3p3c||||||plural:1.000||a|||b|||c}}
*{{xpd5op3p3p3c||||||plural:1,000||a|||b|||c}}

(on e.g. the German and the Dutch sites reversed w.r.t. the result on English sites).

However, this can be used instead of #ifeq, #ifexpr or #switch only for distinguishing a few site-language-specific categories of numbers (for English: 1 and "not equal to 1", for French <=1 and >1, etc.). Also, since it is designed for linguistic distinction of singular and plural, in some languages the categories of numbers are numerically less useful.

== Numbers as output ==
A non-integer result has a decimal point in it. Scientific notation is produced for numbers with small absolute value (for Wikimedia: less than 1E-4) and for numbers with large absolute value (for Wikimedia: greater than or equal to 1E+12; however, even within Wikimedia there is no uniformity, larger numbers in non-scientific notation and smaller numbers in scientific notation have been observed as output; the format of the same number can vary from preview to view, and by refreshing the page!). Thus numbers produced include (depending on the operating system of the server):

*{{xpdoc|#expr: .000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000123456789012345}}
*{{xpdoc|#expr: .00000123456789012345}}
*{{xpdoc|#expr: .0000123456789012345}}
*{{xpdoc|#expr: .000123456789012345}}
*{{xpdoc|#expr: 123456789012.345}}
*{{xpdoc|#expr: 1234567890123.45}}
*{{xpdoc|#expr: 12345678901234.5}}
*{{xpdoc|#expr: 123456789012345}}
*{{xpdoc|#expr: 1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456}}
*{{xpdoc|#expr: 1.234e4}}
*{{xpdoc|#expr: 1.234e-4}}

For negative numbers simply a minus sign is prefixed:
*{{xpdoc|#expr: -123456789012345}}

;Long <tt>YYYYMMDDhhmmss</tt> timestamps can run into the same problem&#58;
:{{xpdoc|CURRENTTIMESTAMP}},
:{{xpdoocc|#expr:|CURRENTTIMESTAMP}}.
;Timestamps without seconds are 12 digits, just short enough&#58;
:{{xpdoc|#expr:{{CURRENTTIMESTAMP}}/100}}

To avoid these problems and also increase accuracy, unless the result is represented by #expr exactly and in non-scientific notation, such as a not too large integer, do not use #expr in an expression to be evaluated by #expr or #ifexpr.  Typically the result of a computational template could be needed in a further computation, so at least one version of such a template needs to give the result in a form suitable for that, e.g. {{tim|roote}} and {{tim|rooteval}}; for convenience, for the final result another version can be made simply calling the other one and applying #expr to the result, e.g. {{tim|rootfineval}}. 

Two methods for representing intermediate results are:

1. The expression resulting from processing the expressions themselves, using #expr for branching only.

For example, {{tim|powe}} produces the power of a number in the form of an expression:
*{{xpd2|powe|31.18|12}}

However, the expression can get quite long, for {{tim|roote}} see  [[Help:Calculation/example 1]]. Although [[Template:Long expression demo|long expressions]] are allowed, they give rise to a large post-expand include size and template argument size, for which limits exist.

Applying #expr directly on the linked expression gives {{#expr:{{roote|.0000000000001}}}}, but it can also be used in a further computation, unlike the value just mentioned.

2. Writing numbers splitting off factors which are powers of 10 but written plainly.

Example:
*{{xpd1|gives=giving|rooteval|.0000000000001}}

Intermediate results are also in such a form, preventing the growth of the expression like above. Again, #expr can be applied directly, as done in {{tim|rootfineval}}, 
giving {{fineval|.0000000000001}}, but the result can also be used in a further computation.

Compare:
*{{xpd1|root|.0000000000001}}

This uses the same method, but with intermediate application of #expr, giving an error  because of internediate results in scientific notation. 

If the result of rounding a negative number is zero, the result is "-0". To avoid that, an expression ''x'' can be replaced by 0 + ( ''x'' ): 
*{{xpd0|#expr: ( -0.2 round 0 )}}
*{{xpd0|#expr: 1*(-0.2 round 0)}}
*{{xpd0|#expr: 0+(-0.2 round 0)}}

The number output is suitable for many other calculation programs, also the scientific notation. In that sense output like 6E23 is more convenient than 6{{e|23}}.

==Accuracy==
: ''The accuracy and format of numeric results varies with the operating system of the server. Some remarks in this section are specific for Wikimedia.''

Accuracy of the result of #expr is less than internally used within the computation of an expression:
* {{xpdoc|#expr:(2/3)}} 
* {{xpdoc|#expr:(2/3)*1000000-666666}} 
* {{xpdoocc|#expr:|#expr:(2/3)| *1000000-666666}}
* {{xpdoc|#expr:1234567890.1234567890-1234567890}} (conclusion: <font color="red">'''16'''</font> or 17 digits of 1234567890.1234567890 used)
* {{xpdoc|#expr:1234567890.1234567890}} (result is rounded to a total of <font color="red">'''12'''</font> digits)
* {{xpdoocc|#expr:(|#expr:1234567890.1234567890| -1234567890)}}

; The [[w:en:Machine epsilon|macheps]] or smallest '''x''' such that '''1+x != 1''' appears to be near <tt>0.5^53&#160;+&#160;0.5^106</tt> or 1.1102230246251566636831481088739149080825883E-<span color="red">'''16'''</span> (see below)&#58;
: <small>{{xpdoc|1=#expr:1=1+0.00000000000000011102230246251566636831481088739149080826}}</small>
: <small>{{xpdoc|1=#expr:1=1+0.00000000000000011102230246251566636831481088739149080825}}</small>

; That's the normal behaviour for [http://www.math.byu.edu/~schow/work/IEEEFloatingPoint.htm 64=1+52+11] bits (52 mantissa, 11 exponent). As explained above it is unrelated to the smallest expression result greater than '''1'''&#58;
: {{xpdoc|#expr:1+0.000000000004999889392}}
: {{xpdoc|#expr:1+0.000000000004999889391}} below about 1 + 5E-<span color="red">'''12'''</span>.

==Branching depending on an expression==
The function [[m:ParserFunctions#.23ifexpr:|#ifexpr]] produces one of two specified results, depending on the value of a boolean expression involving numbers and booleans (not strings). Examples:
* <nowiki>{{#ifexpr: {{CURRENTDOW}} = 0 or {{CURRENTDOW}} = 6 | weekEND | weekDAY}}</nowiki> yields '''{{#ifexpr: {{CURRENTDOW}} = 0 or {{CURRENTDOW}} = 6|weekEND|weekDAY}}''' because today is {{CURRENTDAYNAME}} and so {{xpd0|CURRENTDOW|gives=is}}.
* {{xpd2|1=#ifexpr:2^10=1024|2=1|3=0}}

Note that rounding errors can affect a result:
* {{xpd0|#expr:sin pi}}
* {{xpd2|1=#ifexpr:sin pi=0|2=1|3=0}}
* {{xpd2|#ifexpr:abs sin pi<1e-15|1|0}}

Similarly:
* {{xpd0|1=#expr:sin pi=0}}
* {{xpd0|#expr:abs sin pi<1e-15}}

==Comparisons==
# The function [[m:ParserFunctions#.23ifeq:|#ifeq:]] compares numbers and strings for equality (equal if both represent the same number or both are equal strings).
# The function [[m:ParserFunctions#.23switch:|#switch:]] compares one string with multiple others, and correspondingly produces one of multiple specified results.

* {{xpdopepepec|#switch:FR|UK|London|FR|Paris|NL|Amsterdam}}
<!--
* {{xpd|#switch:UK|UK|3=GB=London|4=FR=Paris}}
* {{xpd|#switch:ZZ|2=UK=London|3=FR=Paris|4=no match}}
-->
* {{xpd3|#ifeq:3|3.0|1|0}}
* {{xpd3|#ifeq:3|03|1|0}}
* {{xpd3|#ifeq:0.00003456|3.456E-05|1|0}}
*: Note that '''#ifeq:''' (like now '''#expr:''') accepts exponential notation on input.
* {{xpd3|#ifeq:1234567890123|1234567890120|1|0}}
* {{xpd3|#ifeq:1234567890123|1.23456789012E+12|1|0}}
* {{xpd3|#ifeq:1234567890120|1.23456789012E+12|1|0}}
* {{xpd3|#ifeq:1.234567890120E12|1.23456789012E+12|1|0}}

Numerical comparisons don't depend on the output format, compare:
* {{xpd0|#expr:1234567890123}}
* {{xpd0|#expr:1234567890120}}

[[ParserFunctions#.23ifeq:|#ifeq:]] allows to compare strings containing equal signs:
{|class="wikitable"
! #switch:
! #ifeq:
|-
| {{xpd|#switch:-1.0|2=-1=okay|3=fail|s=</td><td>}}
| {{xpd|#ifeq:-1.0|-1|okay|fail|s=</td><td>}}
|-
| {{xpd|1=#switch:a=b|2=a=b=okay|3=fail|s=</td><td>}}
| {{xpd|1=#ifeq:a=b|2=a=b|3=okay|4=fail|s=</td><td>}}
|-
| {{xpd|1=#switch:a=c|2=a=b=fail|3=okay|s=</td><td>}}
| {{xpd|1=#ifeq:a=c|2=a=b|3=fail|4=okay|s=</td><td>}}
|}{{-}}

==Length of expressions==
To find the absolute value of a numeric expression x without using a separate template at least doubles the length of the expression:
*''x''<tt>*(1-2*(</tt>''x''<tt><0))</tt>
*x*<nowiki>{{#ifexpr:x>0|1|-1}}</nowiki>
(The first is not only shorter but has also the advantage that for substitution one less "subst:" or <nowiki>{{{subst|}}}</nowiki> is needed.)

Do not use
*<nowiki>{{#ifexpr:x>0|x|-x}}</nowiki>
for long expressions as it triples the length.

Similarly do not use mod to round or conversely, because it doubles the length of the expression.

Also providing a leading zero for the result of an expression if it is less than 10 doubles its length:
*<nowiki>{{#ifexpr:x<10|0}}x</nowiki>

This "exponential" growth of expressions, with much repetition, is due to the lack of variables (in the computer programming sense); however, see also [[VariablesExtension]]. 

Templates (subroutines) provide some of the functionality that variables offer: a template name is comparable with a variable name, while its content is comparable with the value of the variable. Alternatively, a template parameter can be assigned a value which can be used for multiple occurrences of the same parameter in the template. Thus e.g. x*(1-2*(x<0)) with a long expression x can be evaluated avoiding duplication of that expression, in two ways:
*put the expression x in a template (multiple calls of the same template)
*put x*(1-2*(x<0)) in a template with parameter x (use of a template with multiple occurrences of the same parameter)

If the number of possible results of a long expression is small, a  switch allows arbitrary conversion, including the absolute value and providing a leading zero, etc., without repeating the expression.

==Error messages==
Examples for all known [[m:ParserFunctions#.23expr:|#expr:]] and [[m:ParserFunctions#.23ifexpr:|#ifexpr:]] error messages. The error texts are within the tags &lt;strong class="error">..&lt;/strong>.

{| cellspacing="0" cellpadding="0"
|-
||{{xpd1|#expr:1/0|s=</td><td>}}
|-
||{{xpd1|#expr:2*|s=</td><td>}}
|-
||{{xpd1|#expr:1 2|s=</td><td>}}
|-
||{{xpd1|#ifexpr:1*/2|s=</td><td>}}
|-
||{{xpd1|#expr: 1 (2)|s=</td><td>}}
|-
||{{xpd1|#expr: (1 |s=</td><td>}}
|-
||{{xpd1|#expr: 1) |s=</td><td>}}
|-
||{{xpd1|#expr:2*123,456|s=&#160; &#160;</td><td>}}
|-
||{{xpd1|#expr:{{{a}}}|s=</td><td>}}
|-
||{{xpd1|#ifexpr:3%2|s=</td><td>}}
|-
||{{xpd1|#ifexpr:abc|s=</td><td>}}
|-
||{{xpd1|#expr:abc.def|s=</td><td>}}
|-
|colspan="2"|{&#123;<small>&#160;</small><tt>#expr:</tt>{&#123;<small>&#160;</small><tt>x|102|1000*</tt>&#125;}<tt><small>&#160;</small>18</tt><small>&#160;</small>&#125;} gives {{#ifeq:{{ns:4}}|Meta|{{#expr:{{x|102|1000*}}18}}|{{#expr:1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*18}}}} 
|-
|colspan="2"|{&#123;<small>&#160;</small><tt>#expr:</tt>{&#123;<small>&#160;</small><tt>x|102|1000*</tt>&#125;}<tt><small>&#160;</small>179</tt><small>&#160;</small>&#125;} gives {{#ifeq:{{ns:4}}|Meta|{{#expr:{{x|102|1000*}}179}}|{{#expr:1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*179}}}}
|-
|colspan="2"|{&#123;<small>&#160;</small><tt>#expr:</tt>{&#123;<small>&#160;</small><tt>x|102|1000*</tt>&#125;}<tt><small>&#160;</small>180</tt><small>&#160;</small>&#125;} gives {{#ifeq:{{ns:4}}|Meta|{{#expr:{{x|102|1000*}}180}}|{{#expr:1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*1000*180}}}} (on Wikimedia "INF", but depending on the operating system of the server it may also be e.g. "1.#INF")
|-
|colspan="2"|{&#123;<small>&#160;</small><tt>#expr:</tt>{&#123;<small>&#160;</small><tt>x|33|(1+(</tt>&#125;}<small>&#160;</small><tt>1</tt><small>&#160;</small>{&#123;<small>&#160;</small><tt>x|33|))</tt>&#125;} &#125;} gives {{#ifeq:{{ns:4}}|Meta|{{#expr:{{x|33|(1+(}}1{{x|33|))}}}}|{{#expr:(1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+(1)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))}}}} 
|-
|colspan="2"|{&#123;<small>&#160;</small><tt>#expr:</tt>{&#123;<small>&#160;</small><tt>x|34|(1+(</tt>&#125;}<small>&#160;</small><tt>1</tt><small>&#160;</small>{&#123;<small>&#160;</small><tt>x|34|))</tt>&#125;} &#125;} gives {{#ifeq:{{ns:4}}|Meta|{{#expr:{{x|34|(1+(}}1{{x|34|))}}}}|{{#expr:(1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+((1+(1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))}}}}
|-
|colspan="2"|{{xpd0|#expr:3.4.5.6}} &#160; <small>(no feature, only an oddity)</small>
|}

Note: {{links-small|template|x}} copies a given string, here parts of an expression, for the specified times (max. 120), this help page shown on other projects actually evaluate its substituted output like 102 factors "1000" times "180" to get '''INF''' (infinity).
 
Wikitext without error message from the parser functions, but typically an error while using or attempting to use them:

{| cellspacing="0" cellpadding="0"
|-
|valign="top"|<nowiki>{{{#expr:2*3}}}</nowiki> &#160; 
|valign="top"| {{{#expr:2*3}}} &#160;
||(triple braces, the whole is interpreted as parameter tag with parameter name "#expr:2*3")
|-
|valign="top"|<nowiki>{{#expr:2*3}}}</nowiki> 
|valign="top"| {{#expr:2*3}}}
|(one closing brace too many; the last of the three is interpreted as plain text, so that the rest works fine)
|-
|valign="top"|<nowiki>{{{#expr:2*3}}</nowiki> 
|valign="top"| {{{#expr:2*3}}
|(one opening brace too many; the first of the three is interpreted as plain text, so that the rest works fine)
|-
|valign="top"|<nowiki>{{#expr:2*3}</nowiki> 
|valign="top"| {{#expr:2*3}
|(too few braces, the whole is interpreted as plain text)
|}

;A crude but informative "unrecognised word" error message can be generated intentionally. Only the first identified error is shown&#58;
:{&#123;<tt> #expr: 2*</tt>{&#123;<tt> #ifexpr: 3*4>10|toolarge|3*4 </tt>&#125;} &#125;} gives
::{{#expr:2*{{#ifexpr:3*4>10|toolarge|3*4}}}},
:{&#123;<tt> #expr: 2*</tt>{&#123;<tt> #ifexpr: 3*4>10|too large|3*4 </tt>&#125;} &#125;} gives
::{{#expr:2*{{#ifexpr:3*4>10|too large|3*4}}}}.

See also [[Help:ParserFunctions#.23iferror:|#iferror]].

==Minus sign==
Only the {{mlw|hyphen-minus||hyphen-minus}} character or {{mlw|Minus sign|Character codes|minus sign}} character, typed directly, work as a minus sign operator in expressions.
* The HTML character references (by name or by numeric code point value) are not recognized when evaluating expressions: numerical character references are converted only when generating the final HTML document (after expansion of templates and parser functions)
* Only a handful of character references by name are substituted early by MediaWiki, all others are interpreted only by the browser.
* The other dash characters (such as the hyphen, the figure dash, {{mlw|Dash|En dash|en dash}}, {{mlw|Dash|Em dash|em dash}} and others), though often similar visually, are '''not''' valid minus signs, but punctuation signs or typographical variants.

{|class="wikitable"
|-
| {{mlw|hyphen-minus||hyphen-minus}}, typed directly as the character '-' (U+002D)
| {{xpd0|#expr:-12|gives={{!!}}}}
|-
| hyphen-minus, typed as the numerical character reference <tt>&amp;#x2D;</tt>
| <code>"&#x7B;&#x7B;#expr:&amp;#x2D;12&#x7D;&#x7D;"</code>
| "{{#expr:&#x2D;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%23x2D;12%7D%7D}}]
|-
| hyphen-minus, typed as the numerical character reference <tt>&amp;#45;</tt>
| <code>"&#x7B;&#x7B;#expr:&amp;#45;12&#x7D;&#x7D;"</code>
| "{{#expr:&#45;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%2345;12%7D%7D}}]

|-
| {{mlw|Minus sign|Character codes|minus sign}}, typed directly as the character '−' (U+2212)
| {{xpd0|#expr:−12|gives={{!!}}}}
|-
| minus sign, typed as the numerical character reference <tt>&amp;#x2212;</tt>
| <code>"&#x7B;&#x7B;#expr:&amp;#x2212;12&#x7D;&#x7D;"</code>
| "{{#expr:&#x2212;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%23x2212;12%7D%7D}}]
|-
| minus sign, typed as the numerical character reference <tt>&amp;#8722;</tt>
| <code>"&#x7B;&#x7B;#expr:&amp;#8722;12&#x7D;&#x7D;"</code>
| "{{#expr:&#8722;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%238722;12%7D%7D}}]
|-
| minus sign, typed as the symbolic character reference <tt>&amp;minus;</tt>
| <code>"&#x7B;&#x7B;#expr:&amp;minus;12&#x7D;&#x7D;"</code>
| "{{#expr:&minus;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26minus;12%7D%7D}}]

|-
| figure dash, typed directly as the character '‒' (U+2012)
| {{xpd0|#expr:‒12|gives={{!!}}}}
|-
| figure dash, typed as the numerical character reference <tt>&amp;#x2012;</tt>
| <code>"&#x7B;&#x7B;#expr:&amp;#x2012;12&#x7D;&#x7D;"</code>
| "{{#expr:&#x2012;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%23x2012;12%7D%7D}}]
|-
| figure dash, typed as the numerical character reference <tt>&amp;#8210;</tt>
| <code>"&#x7B;&#x7B;#expr:&amp;#8210;12&#x7D;&#x7D;"</code>
| "{{#expr:&#8210;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%238210;12%7D%7D}}]

|-
| {{mlw|Dash|En dash|en dash}}, typed directly as the character '–' (U+2013)
| {{xpd0|#expr:–12|gives={{!!}}}}
|-
| en dash, typed as the numerical character reference <tt>&amp;#x2013;</tt>
| <code>"&#x7B;&#x7B;#expr:&#x26;#x2013;12&#x7D;&#x7D;"</code>
| "{{#expr:&#x2013;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%23x2013;12%7D%7D}}]
|-
| en dash, typed as the numerical character reference <tt>&amp;#8211;</tt>
| <code>"&#x7B;&#x7B;#expr:&#x26;#8211;12&#x7D;&#x7D;"</code>
| "{{#expr:&#8211;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26%238211;12%7D%7D}}]
|-
| en dash, typed as the symbolic character reference <tt>&amp;ndash;</tt>
| <code>"&#x7B;&#x7B;#expr:&#x26;ndash;12&#x7D;&#x7D;"</code>
| "{{#expr:&ndash;12}}"
| [{{fullurl:Special:ExpandTemplates|input=%7B%7B%23expr:%26ndash;12%7D%7D}}]
|}

Also many other calculation programs require a hyphen. Therefore, in order to be able to copy rendered numbers and expressions to the edit box or input them through a copy operation into other calculation programs, displayed minus signs also need to be hyphens.

==Displaying numbers and numeric expressions==
Guidelines such as {{mlww|Manual of Style (dates and numbers)|Numbers}} focus on number display as end product. However, a point of consideration can also be the possibility to apply the rendered output to #expr or #ifexpr, or to input it without conversion into other calculation programs. This would require the following:
*use digits, not words
*as mentioned above, use the hyphen as minus sign
*use *, <=, and >=, not ×, ≤, or ≥
*do not use thousands separators (however, some programs allow them)
*use output like 6E23 or 6e23 rather than 6{{e|23}}

Examples:
*{{xpd0|#expr:three}}
*{{xpd0|#expr:2<3}}
*{{xpd0|#expr:2≤3}}
*{{xpd0|#expr:2<{{=}}3}}
*{{xpd0|#expr:2>3}}
*{{xpd0|#expr:2≥3}}
*{{xpd0|#expr:2>{{=}}3}}
*{{xpd0|#expr:2*3}}
*{{xpd0|#expr:2×3}}
*{{xpd0|#expr:2,300}}
*{{xpd0|#expr:6E23}}

If the number is the result of a computation by MediaWiki and unsuitable for use in a new computation due to application of a formatting function such as #formatnum or a formatting template, one can copy the wikitext and apply the additional computation before the formatting. However, when templates are used, and copying is done to another wiki, these templates have to be copied too, or substituted.

== See also ==
*[[Help:Modulo and round]]
*[[:Category:Mathematical templates]]
*[[mw:Extension:MathStatFunctions]]

{{h:f|enname=Calculation}}