Help:Calculation

Revision as of 21:35, 2 July 2013

The accuracy and format of numeric results varies with the server; even on a single page, while for any rendering there is consistency within the page, there is no consistency among renderings.

The MediaWiki extension ParserFunctions enables users to perform calculations, for simple arithmetic or for functions as on a scientific calculator, with rounding, floor, logarithms (ln), sine, cosine, or modulo (etc.), plus boolean comparisons with "=" or "<" or ">=" etc.

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

{{ #expr: expression }} - Spaces are not required, but spaces/commas within numbers are not allowed.

The supported operators (roughly in order of precedence) are: not, ^, *, /, div, mod, +, -, round, trunc, =, <>, !=, <=, >=, and, and or. Functions include: abs( ), ceil( ), floor( ), ln( ), sin( ), cos( ), tan( ), etc.

The precision supports 14-digit numbers (pi: {{#expr:pi}}, or longer on some servers) and E-notation ("1.54E17"), but truncation error can cause mismatches on comparisons of very large numbers or tiny decimals, so see below: "Tactics for handling extreme numbers".

Operators

Operator Operation Examples

none

Template:Xpd/wl\|#expr:123456789012345}}}}"	"{{#expr:123456789012345}}" {{#ifeq:	}} [1]
Template:Xpd/wl\|#expr:1.23456789012345}}}}"	"{{#expr:1.23456789012345}}" {{#ifeq:	}} [2]
Template:Xpd/wl\|#expr:.000001}}}}"	"{{#expr:.000001}}" {{#ifeq:	}} [3]
Template:Xpd/wl\|#expr:.00000123456789012345}}}}"	"{{#expr:.00000123456789012345}}" {{#ifeq:	}} [4]
Template:Xpd/wl\|#expr:.123e4}}}}"	"{{#expr:.123e4}}" {{#ifeq:	}} [5]
Template:Xpd/wl\|#expr:123E-2}}}}"	"{{#expr:123E-2}}" {{#ifeq:	}} [6]
Template:Xpd/wl\|#expr:e}}}}"	"{{#expr:e}}" {{#ifeq:	}} [7]
Template:Xpd/wl\|#expr:pi}}}}"	"{{#expr:pi}}" {{#ifeq:	}} [8]

Wrong:

Template:Xpd/wl\|#expr:e4}}}}"	"{{#expr:e4}}" {{#ifeq:				}} [9]

exp

e to the specified power

Template:Xpd/wl\|#expr:exp1.2}}}}"	"{{#expr:exp1.2}}" {{#ifeq:				}} [10]

Compare:

Template:Xpd/wl\|#expr:e^1.2}}}}"	"{{#expr:e^1.2}}" {{#ifeq:				}} [11]

ln

Natural logarithm

Template:Xpd/wl\|#expr:ln2}}}}"	"{{#expr:ln2}}" {{#ifeq:				}} [12]

Hence, the base ten logarithm of e.g. 2:

Template:Xpd/wl\|#expr:ln2/ln10}}}}"	"{{#expr:ln2/ln10}}" {{#ifeq:				}} [13]

abs

Template:Xpd/wl\|#expr:abs-1.2}}}}"	"{{#expr:abs-1.2}}" {{#ifeq:				}} [14]

trunc

Template:Xpd/wl\|#expr:trunc1.2}}}}"	"{{#expr:trunc1.2}}" {{#ifeq:				}} [15]
Template:Xpd/wl\|#expr:trunc-1.2}}}}"	"{{#expr:trunc-1.2}}" {{#ifeq:				}} [16]

floor

Template:Xpd/wl\|#expr:floor1.2}}}}"	"{{#expr:floor1.2}}" {{#ifeq:				}} [17]
Template:Xpd/wl\|#expr:floor-1.2}}}}"	"{{#expr:floor-1.2}}" {{#ifeq:				}} [18]

ceil

Template:Xpd/wl\|#expr:ceil1.2}}}}"	"{{#expr:ceil1.2}}" {{#ifeq:				}} [19]
Template:Xpd/wl\|#expr:ceil-1.2}}}}"	"{{#expr:ceil-1.2}}" {{#ifeq:				}} [20]

sin

Template:Xpd/wl\|#expr:sin.1}}}}"	"{{#expr:sin.1}}" {{#ifeq:				}} [21]

With an angle in degrees, e.g. 30°:

Template:Xpd/wl\|#expr:sin(30*pi/180)}}}}"	"{{#expr:sin(30*pi/180)}}" {{#ifeq:				}} [22]

cos

Template:Xpd/wl\|#expr:cos.1}}}}"	"{{#expr:cos.1}}" {{#ifeq:				}} [23]

tan

Template:Xpd/wl\|#expr:tan.1}}}}"	"{{#expr:tan.1}}" {{#ifeq:				}} [24]

asin

Template:Xpd/wl\|#expr:asin.1}}}}"	"{{#expr:asin.1}}" {{#ifeq:				}} [25]

acos

Template:Xpd/wl\|#expr:acos.1}}}}"	"{{#expr:acos.1}}" {{#ifeq:				}} [26]

atan

Template:Xpd/wl\|#expr:atan.1}}}}"	"{{#expr:atan.1}}" {{#ifeq:				}} [27]

+

Unary + sign

Template:Xpd/wl\|#expr:+12}}}}"	"{{#expr:+12}}" {{#ifeq:	}} [28]
Template:Xpd/wl\|#expr:++12}}}}"	"{{#expr:++12}}" {{#ifeq:	}} [29]
Template:Xpd/wl\|#expr:+-12}}}}"	"{{#expr:+-12}}" {{#ifeq:	}} [30]

-

Unary - sign (negation)

Template:Xpd/wl\|#expr:-12}}}}"	"{{#expr:-12}}" {{#ifeq:	}} [31]
Template:Xpd/wl\|#expr:-+12}}}}"	"{{#expr:-+12}}" {{#ifeq:	}} [32]
Template:Xpd/wl\|#expr:--12}}}}"	"{{#expr:--12}}" {{#ifeq:	}} [33]

not

Unary NOT, logical NOT

Template:Xpd/wl\|#expr:not 0}}}}"	"{{#expr:not 0}}" {{#ifeq:	}} [34]
Template:Xpd/wl\|#expr:not 1}}}}"	"{{#expr:not 1}}" {{#ifeq:	}} [35]
Template:Xpd/wl\|#expr:not 2}}}}"	"{{#expr:not 2}}" {{#ifeq:	}} [36]

^

Power

Template:Xpd/wl\|#expr:2^7}}}}"	"{{#expr:2^7}}" {{#ifeq:	}} [37]
Template:Xpd/wl\|#expr:2^-7}}}}"	"{{#expr:2^-7}}" {{#ifeq:	}} [38]
Template:Xpd/wl\|#expr:(-2)^7}}}}"	"{{#expr:(-2)^7}}" {{#ifeq:	}} [39]
Template:Xpd/wl\|#expr:(-2)^8}}}}"	"{{#expr:(-2)^8}}" {{#ifeq:	}} [40]
Template:Xpd/wl\|#expr:2^1.2}}}}"	"{{#expr:2^1.2}}" {{#ifeq:	}} [41]
Template:Xpd/wl\|#expr:2^.5}}}}"	"{{#expr:2^.5}}" {{#ifeq:	}} [42]
Template:Xpd/wl\|#expr:(-2)^1.2}}}}"	"{{#expr:(-2)^1.2}}" {{#ifeq:	}} [43]
Template:Xpd/wl\|#expr:(-2)^.5}}}}"	"{{#expr:(-2)^.5}}" {{#ifeq:	}} [44]

*

Multiplication

Template:Xpd/wl\|#expr:30*7}}}}"	"{{#expr:30*7}}" {{#ifeq:				}} [45]
Template:Xpd/wl\|#expr:30*-7}}}}"	"{{#expr:30*-7}}" {{#ifeq:				}} [46]

/

Division, same as div

Template:Xpd/wl\|#expr:30/7}}}}"	"{{#expr:30/7}}" {{#ifeq:				}} [47]
Template:Xpd/wl\|#expr:30/-7}}}}"	"{{#expr:30/-7}}" {{#ifeq:				}} [48]

div

Division, same as /,
not integer division

Template:Xpd/wl\|#expr:30 div 7}}}}"	"{{#expr:30 div 7}}" {{#ifeq:				}} [49] (should be 4)

mod

"Modulo", remainder of division after truncating both operands to an integer (PHP operator %).

Caveat, div and mod are different from all programming languages. This has been fixed (but needs to be committed), see bugzilla:6068.

Template:Xpd/wl\|#expr:30 mod 7}}}}"	"{{#expr:30 mod 7}}" {{#ifeq:	}} [50]
Template:Xpd/wl\|#expr:30 mod -7}}}}"	"{{#expr:30 mod -7}}" {{#ifeq:	}} [51]
Template:Xpd/wl\|#expr:-30 mod 7}}}}"	"{{#expr:-30 mod 7}}" {{#ifeq:	}} [52]
Template:Xpd/wl\|#expr:-30 mod -7}}}}"	"{{#expr:-30 mod -7}}" {{#ifeq:	}} [53]
Template:Xpd/wl\|#expr:-8 mod -3}}}}"	"{{#expr:-8 mod -3}}" {{#ifeq:	}} [54]
Template:Xpd/wl\|#expr:-8 mod 2.9}}}}"	"{{#expr:-8 mod 2.9}}" {{#ifeq:	}} [55] (should be 2.6)
Template:Xpd/wl\|#expr:-8 mod 3.2}}}}"	"{{#expr:-8 mod 3.2}}" {{#ifeq:	}} [56] (should be 1.6)
Template:Xpd/wl\|#expr:8.9 mod 3}}}}"	"{{#expr:8.9 mod 3}}" {{#ifeq:	}} [57] (should be 2.9)

+

Addition

Template:Xpd/wl\|#expr:30 + 7}}}}"	"{{#expr:30 + 7}}" {{#ifeq:				}} [58]

-

Subtraction

Template:Xpd/wl\|#expr:30 - 7}}}}"	"{{#expr:30 - 7}}" {{#ifeq:				}} [59]

round

Rounds off the number on the left to the power of 1/10 given on the right (PHP function round)

Template:Xpd/wl\|#expr:4.2857 round 3}}}}"	"{{#expr:4.2857 round 3}}" {{#ifeq:	}} [60]
Template:Xpd/wl\|#expr:4.2857 round 0}}}}"	"{{#expr:4.2857 round 0}}" {{#ifeq:	}} [61]
Template:Xpd/wl\|#expr:42857 round -2}}}}"	"{{#expr:42857 round -2}}" {{#ifeq:	}} [62]
Template:Xpd/wl\|#expr:4.5 round 0}}}}"	"{{#expr:4.5 round 0}}" {{#ifeq:	}} [63]
Template:Xpd/wl\|#expr:-4.5 round 0}}}}"	"{{#expr:-4.5 round 0}}" {{#ifeq:	}} [64]

=

Equality (numerical incl. logical)

Template:Xpd/wl\|#expr:3=03.0}}}}"	"{{#expr:3=03.0}}" {{#ifeq:				}} [65]

<>

Inequality, same as !=

Template:Xpd/wl\|#expr:3<>03.0}}}}"	"{{#expr:3<>03.0}}" {{#ifeq:				}} [66]
Template:Xpd/wl\|#expr:3<>4}}}}"	"{{#expr:3<>4}}" {{#ifeq:				}} [67]

!=

Inequality, same as <>, logical xor

Template:Xpd/wl\|#expr:3!=03.0}}}}"	"{{#expr:3!=03.0}}" {{#ifeq:				}} [68]
Template:Xpd/wl\|#expr:3!=4}}}}"	"{{#expr:3!=4}}" {{#ifeq:				}} [69]

<

Less than

Template:Xpd/wl\|#expr:3<2}}}}"	"{{#expr:3<2}}" {{#ifeq:	}} [70]
Template:Xpd/wl\|#expr:3<3}}}}"	"{{#expr:3<3}}" {{#ifeq:	}} [71]
Template:Xpd/wl\|#expr:3<4}}}}"	"{{#expr:3<4}}" {{#ifeq:	}} [72]

>

Greater than

Template:Xpd/wl\|#expr:3>2}}}}"	"{{#expr:3>2}}" {{#ifeq:	}} [73]
Template:Xpd/wl\|#expr:3>3}}}}"	"{{#expr:3>3}}" {{#ifeq:	}} [74]
Template:Xpd/wl\|#expr:3>4}}}}"	"{{#expr:3>4}}" {{#ifeq:	}} [75]

<=

Less than or equal to

Template:Xpd/wl\|#expr:3<=2}}}}"	"{{#expr:3<=2}}" {{#ifeq:	}} [76]
Template:Xpd/wl\|#expr:3<=3}}}}"	"{{#expr:3<=3}}" {{#ifeq:	}} [77]
Template:Xpd/wl\|#expr:3<=4}}}}"	"{{#expr:3<=4}}" {{#ifeq:	}} [78]

>=

Greater than or equal to

Template:Xpd/wl\|#expr:3>=2}}}}"	"{{#expr:3>=2}}" {{#ifeq:	}} [79]
Template:Xpd/wl\|#expr:3>=3}}}}"	"{{#expr:3>=3}}" {{#ifeq:	}} [80]
Template:Xpd/wl\|#expr:3>=4}}}}"	"{{#expr:3>=4}}" {{#ifeq:	}} [81]

and

Logical AND

Template:Xpd/wl\|#expr:3 and 4}}}}"	"{{#expr:3 and 4}}" {{#ifeq:	}} [82]
Template:Xpd/wl\|#expr:0 and 3}}}}"	"{{#expr:0 and 3}}" {{#ifeq:	}} [83]
Template:Xpd/wl\|#expr:-3 and 0}}}}"	"{{#expr:-3 and 0}}" {{#ifeq:	}} [84]
Template:Xpd/wl\|#expr:0 and 0}}}}"	"{{#expr:0 and 0}}" {{#ifeq:	}} [85]

or

Logical OR

Template:Xpd/wl\|#expr:3 or 4}}}}"	"{{#expr:3 or 4}}" {{#ifeq:	}} [86]
Template:Xpd/wl\|#expr:0 or 3}}}}"	"{{#expr:0 or 3}}" {{#ifeq:	}} [87]
Template:Xpd/wl\|#expr:-3 or 0}}}}"	"{{#expr:-3 or 0}}" {{#ifeq:	}} [88]
Template:Xpd/wl\|#expr:0 or 0}}}}"	"{{#expr:0 or 0}}" {{#ifeq:	}} [89]

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 "{{{{#if:|Template:Xpd/wl|#expr: (2 < 3) + 1}}}}" gives "{{#expr: (2 < 3) + 1}}" {{#ifeq:{{{gives}}}||||||}} [90]. 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 {{ #expr: {{#if:{{{a}}}|1|0}} or {{#if:{{{b}}}|1|0}} }} we can also use {{#if:{{{a}}}{{{b}}}|1|0}}}}. For negation, simply subtract from 1 or interchange then- and else-part.

Precedence:

"{{{{#if:|Template:Xpd/wl|#expr: 2 - 3 + 4 / 5 * 6}}}}" gives "{{#expr: 2 - 3 + 4 / 5 * 6}}" {{#ifeq:{{{gives}}}||||||}} [91]

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

"{{{{#if:|Template:Xpd/wl|#expr: 2 = 5 < 3 + 4}}}}" gives "{{#expr: 2 = 5 < 3 + 4}}" {{#ifeq:{{{gives}}}||||||}} [92]

(first +, then =, then <).

"{{{{#if:|Template:Xpd/wl|#expr:1.234 + 1.234 round 1 + 1 }}}}" gives "{{#expr:1.234 + 1.234 round 1 + 1 }}" {{#ifeq:{{{gives}}}||||||}} [93]

(first additions, then round)

"{{{{#if:|Template:Xpd/wl|#expr:3 * 4 mod 10 * 10 }}}}" gives "{{#expr:3 * 4 mod 10 * 10 }}" {{#ifeq:{{{gives}}}||||||}} [94]

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

Parentheses can force a different precedence: "{{{{#if:|Template:Xpd/wl|#expr: (2 + 3) * 4}}}}" gives "{{#expr: (2 + 3) * 4}}" {{#ifeq:{{{gives}}}||||||}} [95]

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:

"{{{{#if:|Template:Xpd/wl|#expr:7mod3}}}}" gives "{{#expr:7mod3}}" {{#ifeq:{{{gives}}}||||||}} [96]
"{{{{#if:|Template:Xpd/wl|#expr:7.5round0}}}}" gives "{{#expr:7.5round0}}" {{#ifeq:{{{gives}}}||||||}} [97]
"{{{{#if:|Template:Xpd/wl|#expr:0and1}}}}" gives "{{#expr:0and1}}" {{#ifeq:{{{gives}}}||||||}} [98]
"{{{{#if:|Template:Xpd/wl|#expr:0or not0}}}}" gives "{{#expr:0or not0}}" {{#ifeq:{{{gives}}}||||||}} [99]
"{{{{#if:|Template:Xpd/wl|#expr:0ornot0}}}}" gives "{{#expr:0ornot0}}" {{#ifeq:{{{gives}}}||||||}} [100]
"{{{{#if:|Template:Xpd/wl|#expr:123 456}}}}" gives "{{#expr:123 456}}" {{#ifeq:{{{gives}}}||||||}} [101]
"{{{{#if:|Template:Xpd/wl|#expr:not not3}}}}" gives "{{#expr:not not3}}" {{#ifeq:{{{gives}}}||||||}} [102]
"{{{{#if:|Template:Xpd/wl|#expr:notnot3}}}}" gives "{{#expr:notnot3}}" {{#ifeq:{{{gives}}}||||||}} [103]

"{{{{#if:|Template:Xpd/wl|#expr:---2}}}}" gives "{{#expr:---2}}" {{#ifeq:{{{gives}}}||||||}} [104]
"{{{{#if:|Template:Xpd/wl|#expr:-+-2}}}}" gives "{{#expr:-+-2}}" {{#ifeq:{{{gives}}}||||||}} [105]
"{{{{#if:|Template:Xpd/wl|#expr:2*-3}}}}" gives "{{#expr:2*-3}}" {{#ifeq:{{{gives}}}||||||}} [106]
"{{{{#if:|Template:Xpd/wl|#expr:-not-not-not0}}}}" gives "{{#expr:-not-not-not0}}" {{#ifeq:{{{gives}}}||||||}} [107]
"{{{{#if:|Template:Xpd/wl|#expr:2*/3}}}}" gives "{{#expr:2*/3}}" {{#ifeq:{{{gives}}}||||||}} [108]
"{{{{#if:|Template:Xpd/wl|#expr:sinln1.1}}}}" gives "{{#expr:sinln1.1}}" {{#ifeq:{{{gives}}}||||||}} [109]
"{{{{#if:|Template:Xpd/wl|#expr:sin ln1.1}}}}" gives "{{#expr:sin ln1.1}}" {{#ifeq:{{{gives}}}||||||}} [110]

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.

"{{{{#if:|Template:Xpd/wl|#expr: +01.20}}}}" gives "{{#expr: +01.20}}" {{#ifeq:{{{gives}}}||||||}} [111]
"{{{{#if:|Template:Xpd/wl|#expr: 12.}}}}" gives "{{#expr: 12.}}" {{#ifeq:{{{gives}}}||||||}} [112]

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

In [113] 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 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. (For the purpose of evaluating an expression a plus or minus sign is considered a unary operator instead of part of the number.)

Canonical form:

"{{{{#if:|Template:Xpd/wl|#expr: 123}}}}" gives "{{#expr: 123}}" {{#ifeq:{{{gives}}}||||||}} [114]
"{{{{#if:|Template:Xpd/wl|#expr: 123.456}}}}" gives "{{#expr: 123.456}}" {{#ifeq:{{{gives}}}||||||}} [115]
"{{{{#if:|Template:Xpd/wl|#expr: 0.456}}}}" gives "{{#expr: 0.456}}" {{#ifeq:{{{gives}}}||||||}} [116]
"{{{{#if:|Template:Xpd/wl|#expr: 0}}}}" gives "{{#expr: 0}}" {{#ifeq:{{{gives}}}||||||}} [117]
"{{{{#if:|Template:Xpd/wl|#expr: 2.0E-5}}}}" gives "{{#expr: 2.0E-5}}" {{#ifeq:{{{gives}}}||||||}} [118]

Accepted, although in some cases more or less odd:

"{{{{#if:|Template:Xpd/wl|#expr: .456}}}}" gives "{{#expr: .456}}" {{#ifeq:{{{gives}}}||||||}} [119]
"{{{{#if:|Template:Xpd/wl|#expr: 123.}}}}" gives "{{#expr: 123.}}" {{#ifeq:{{{gives}}}||||||}} [120]
"{{{{#if:|Template:Xpd/wl|#expr: 000123}}}}" gives "{{#expr: 000123}}" {{#ifeq:{{{gives}}}||||||}} [121]
"{{{{#if:|Template:Xpd/wl|#expr: 123.456.789}}}}" gives "{{#expr: 123.456.789}}" {{#ifeq:{{{gives}}}||||||}} [122]
"{{{{#if:|Template:Xpd/wl|#expr: .}}}}" gives "{{#expr: .}}" {{#ifeq:{{{gives}}}||||||}} [123]
"{{{{#if:|Template:Xpd/wl|#expr: 2e-5}}}}" gives "{{#expr: 2e-5}}" {{#ifeq:{{{gives}}}||||||}} [124]
"{{{{#if:|Template:Xpd/wl|#expr: 2E-5}}}}" gives "{{#expr: 2E-5}}" {{#ifeq:{{{gives}}}||||||}} [125]
"{{{{#if:|Template:Xpd/wl|#expr: E}}}}" gives "{{#expr: E}}" {{#ifeq:{{{gives}}}||||||}} [126]
"{{{{#if:|Template:Xpd/wl|#expr: e}}}}" gives "{{#expr: e}}" {{#ifeq:{{{gives}}}||||||}} [127]
"{{{{#if:|Template:Xpd/wl|#expr: E-5}}}}" gives "{{#expr: E-5}}" {{#ifeq:{{{gives}}}||||||}} [128]
"{{{{#if:|Template:Xpd/wl|#expr: e-5}}}}" gives "{{#expr: e-5}}" {{#ifeq:{{{gives}}}||||||}} [129]
"{{{{#if:|Template:Xpd/wl|#expr: 1e-5}}}}" gives "{{#expr: 1e-5}}" {{#ifeq:{{{gives}}}||||||}} [130]

Wrong:

"{{{{#if:|Template:Xpd/wl|#expr: 123,456}}}}" gives "{{#expr: 123,456}}" {{#ifeq:{{{gives}}}||||||}} [131]
"{{{{#if:|Template:Xpd/wl|#expr: 123 456}}}}" gives "{{#expr: 123 456}}" {{#ifeq:{{{gives}}}||||||}} [132]

As opposed to ParserFunctions, "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:

(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 ( less than 1E-4) and for numbers with large absolute value ( greater than or equal to 1E+12; however, even within MediaWiki 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):

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: .000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000123456789012345}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: .00000123456789012345}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: .0000123456789012345}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: .000123456789012345}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: 123456789012.345}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: 1234567890123.45}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: 12345678901234.5}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: 123456789012345}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: 1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: 1.234e4}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: 1.234e-4}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

For negative numbers simply a minus sign is prefixed:

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr: -123456789012345}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

Long YYYYMMDDhhmmss timestamps can run into the same problem: {{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|CURRENTTIMESTAMP}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

Template:Xpdoocc.
Timestamps without seconds are 12 digits, just short enough: {{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:20241123141401/100}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

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. Template:roote and Template: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. Template:rootfineval.

Two methods for representing intermediate results are:

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

For example, Template:powe produces the power of a number in the form of an expression:

Template:Xpd2

However, the expression can get quite long, for Template:roote see Help:Calculation/example 1. Although 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 a linked expression gives {{#expr:Template:Roote}}, 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:

Template:Xpd1

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 Template:rootfineval, giving Template:Fineval, but the result can also be used in a further computation.

Compare:

"{{{{#if:|Template:Xpd/wl|#expr:(.0000000000001)^(1/2)}}}}" gives "{{#expr:(.0000000000001)^(1/2)}}" {{#ifeq:{{{gives}}}||||||}} [133]

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 ):

"{{{{#if:|Template:Xpd/wl|#expr: ( -0.2 round 0 )}}}}" gives "{{#expr: ( -0.2 round 0 )}}" {{#ifeq:{{{gives}}}||||||}} [134]
"{{{{#if:|Template:Xpd/wl|#expr: 1*(-0.2 round 0)}}}}" gives "{{#expr: 1*(-0.2 round 0)}}" {{#ifeq:{{{gives}}}||||||}} [135]
"{{{{#if:|Template:Xpd/wl|#expr: 0+(-0.2 round 0)}}}}" gives "{{#expr: 0+(-0.2 round 0)}}" {{#ifeq:{{{gives}}}||||||}} [136]

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{{#if:23

|×10^{{{#switch:{{{2}}}
 |#default={{#switch:{{#if:23|{{#ifeq:23|{{#if:{{#ifexpr:{{#expr:23}}}}|(23)|{{#expr:23}}}}|true|{{#ifeq:23|+{{#if:{{#ifexpr:{{#expr:23}}}}|(23)|{{#expr:23}}}}|true|{{#ifeq:23|({{#if:{{#ifexpr:{{#expr:23}}}}|(23)|{{#expr:23}}}})|true|false}}}}}}}}
  |#default={{#switch:{{{2}}}
   |plus=+{{#ifexpr:(231)=(23)|Template:FormattingError|{{#ifexpr:23<0|−}}{{#ifexpr:abs(231)>10*abs(23)|{{#expr:abs(23)}}|{{#expr:trunc(abs(23))}}.{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>14|Template:FormattingError|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=1|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E1mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=2|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E2mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=3|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E3mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=4|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>4|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E4mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=5|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E5mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=6|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E6mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=7|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>7|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E7mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=8|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E8mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=9|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E9mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=10|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>10|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E10mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=11|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E11mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=12|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E12mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=13|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>13|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E13mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=14|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E14mod10}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}
   |#default={{#ifexpr:(231)=(23)|Template:FormattingError|{{#ifexpr:23<0|−}}{{#ifexpr:abs(231)>10*abs(23)|{{#expr:abs(23)}}|{{#expr:trunc(abs(23))}}.{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>14|Template:FormattingError|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=1|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E1mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=2|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E2mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=3|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E3mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=4|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>4|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E4mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=5|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E5mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=6|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E6mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=7|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>7|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E7mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=8|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E8mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=9|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E9mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=10|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>10|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E10mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=11|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E11mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=12|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E12mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=13|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>13|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E13mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=14|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E14mod10}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}
  }}
  |false=23
 }}
 |text=23
}}}
|^e

}}.

Accuracy

The accuracy and format of numeric results varies with the operating system of the server.

Accuracy of the result of #expr is less than internally used within the computation of an expression:

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:(2/3)}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:(2/3)*1000000-666666}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

Template:Xpdoocc
{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:1234567890.1234567890-1234567890}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:1234567890.1234567890}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

Template:Xpdoocc

The macheps or smallest x such that 1+x != 1 appears to be near 0.5^53 + 0.5^106 or 1.1102230246251566636831481088739149080825883E-16 (see above)
{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:1=1+0.00000000000000011102230246251566636831481088739149080826}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:1=1+0.00000000000000011102230246251566636831481088739149080825}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

That's the normal behaviour for 64=1+52+11 bits (52 mantissa, 11 exponent). As explained above it is unrelated to the smallest expression result greater than 1
{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:1+0.000000000004999889392}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

{{xpd/w{{#if:|l}}|"}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|{}}{{xpd/w{{#if:|l}}|#expr:1+0.000000000004999889391}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|}}}{{xpd/w{{#if:|l}}|{{{{{#switch:pq|p q=2|p

Branching depending on an expression

The function #ifexpr produces one of two specified results, depending on the value of a boolean expression involving numbers and booleans (not strings). Examples:

{{#ifexpr: {{CURRENTDOW}} = 0 or {{CURRENTDOW}} = 6 | weekEND | weekDAY}} yields {{#ifexpr: 6 = 0 or 6 = 6|weekEND|weekDAY}} because today is Saturday and so "{{{{#if:|Template:Xpd/wl|CURRENTDOW}}}}" is "6" {{#ifeq: is||||||}} [137].

Template:Xpd2

Note that rounding errors can affect a result:

"{{{{#if:|Template:Xpd/wl|#expr:sin pi}}}}" gives "{{#expr:sin pi}}" {{#ifeq:{{{gives}}}||||||}} [138]
Template:Xpd2
Template:Xpd2

Similarly:

"{{{{#if:|Template:Xpd/wl|#expr:sin pi=0}}}}" gives "{{#expr:sin pi=0}}" {{#ifeq:{{{gives}}}||||||}} [139]
"{{{{#if:|Template:Xpd/wl|#expr:abs sin pi<1e-15}}}}" gives "{{#expr:abs sin pi<1e-15}}" {{#ifeq:{{{gives}}}||||||}} [140]

Comparisons

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

Template:Xpdopepepec

Note that #ifeq: unlike #expr: accepts exponential notation on input.

{{#ifexpr:0.00003456 = 3.456E-05|1|0}} gives "{{#ifexpr:0.00003456 = 3.456E-05|1|0}}"

Template:Xpd3
Template:Xpd3
Template:Xpd3
Template:Xpd3
Numerical comparisons don't depend on the output format, compare:
"{{{{#if:|Template:Xpd/wl|#expr:1234567890123}}}}" gives "{{#expr:1234567890123}}" {{#ifeq:{{{gives}}}||||||}} [141]
"{{{{#if:|Template:Xpd/wl|#expr:1234567890120}}}}" gives "{{#expr:1234567890120}}" {{#ifeq:{{{gives}}}||||||}} [142]

#ifeq: allows to compare strings containing equal signs:

#switch form	#ifeq form
{{`{{{1n}}}`}}`}}{{#ifeq:+\|-\|\|-1=okay\|fail\|\|{{#ifeq:fail\|fail\|\|-1=okay\|fail\|{{#ifeq:-1=okay\|-1=okay\|\|-1=okay\|}}}}}}`}} </td><td> {{#ifeq:-\|+\|{{#switch:-1.0\|-1=okay\|fail\|}}\|{{#ifeq:fail\|fail\|{{#switch:-1.0\|-1=okay\|fail}}\|{{#ifeq:-1=okay\|-1=okay\|{{#switch:-1.0\|-1=okay}}\|{{#switch:-1.0}}}}}}}}	{{`{{{1n}}}`}}`}}{{#ifeq:fail\|fail\|\|-1\|okay\|fail\|{{#ifeq:okay\|okay\|\|-1\|okay\|{{#ifeq:-1\|-1\|\|-1\|}}}}}}`}} </td><td> {{#ifeq:fail\|fail\|{{#ifeq:-1.0\|-1\|okay\|fail}}\|{{#ifeq:okay\|okay\|{{#ifeq:-1.0\|-1\|okay}}\|{{#ifeq:-1\|-1\|{{#ifeq:-1.0\|-1}}\|{{#ifeq:-1.0}}}}}}}}
-1=okay\|fail}}"
{{`{{{1n}}}`}}`}}{{#ifeq:+\|-\|\|a=b=okay\|fail\|\|{{#ifeq:fail\|fail\|\|a=b=okay\|fail\|{{#ifeq:a=b=okay\|a=b=okay\|\|a=b=okay\|}}}}}}`}} </td><td> {{#ifeq:-\|+\|{{#switch:a=b\|a=b=okay\|fail\|}}\|{{#ifeq:fail\|fail\|{{#switch:a=b\|a=b=okay\|fail}}\|{{#ifeq:a=b=okay\|a=b=okay\|{{#switch:a=b\|a=b=okay}}\|{{#switch:a=b}}}}}}}}	{{`{{{1n}}}`}}`}}{{#ifeq:fail\|fail\|\|a=b\|okay\|fail\|{{#ifeq:okay\|okay\|\|a=b\|okay\|{{#ifeq:a=b\|a=b\|\|a=b\|}}}}}}`}} </td><td> {{#ifeq:fail\|fail\|{{#ifeq:a=b\|a=b\|okay\|fail}}\|{{#ifeq:okay\|okay\|{{#ifeq:a=b\|a=b\|okay}}\|{{#ifeq:a=b\|a=b\|{{#ifeq:a=b\|a=b}}\|{{#ifeq:a=b}}}}}}}}
{{`{{{1n}}}`}}`}}{{#ifeq:+\|-\|\|a=b=fail\|okay\|\|{{#ifeq:okay\|okay\|\|a=b=fail\|okay\|{{#ifeq:a=b=fail\|a=b=fail\|\|a=b=fail\|}}}}}}`}} </td><td> {{#ifeq:-\|+\|{{#switch:a=c\|a=b=fail\|okay\|}}\|{{#ifeq:okay\|okay\|{{#switch:a=c\|a=b=fail\|okay}}\|{{#ifeq:a=b=fail\|a=b=fail\|{{#switch:a=c\|a=b=fail}}\|{{#switch:a=c}}}}}}}}	{{`{{{1n}}}`}}`}}{{#ifeq:okay\|okay\|\|a=b\|fail\|okay\|{{#ifeq:fail\|fail\|\|a=b\|fail\|{{#ifeq:a=b\|a=b\|\|a=b\|}}}}}}`}} </td><td> {{#ifeq:okay\|okay\|{{#ifeq:a=c\|a=b\|fail\|okay}}\|{{#ifeq:fail\|fail\|{{#ifeq:a=c\|a=b\|fail}}\|{{#ifeq:a=b\|a=b\|{{#ifeq:a=c\|a=b}}\|{{#ifeq:a=c}}}}}}}}

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*(1-2*(x<0))
x*{{#ifexpr:x>0|1|-1}}

(The first is not only shorter but has also the advantage that for substitution one less "subst:" or {{{subst|}}} is needed.)

Do not use

{{#ifexpr:x>0|x|-x}}

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:

{{#ifexpr:x<10|0}}x

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)

For the pre-expand include size maximum the first method does not help, but the second does.

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 #expr: and #ifexpr: error messages. The error texts are within the tags <strong class="error">..</strong>. Note that with the old preprocessor the "=" in "class=error" disturbs the numbering of unnamed parameters, if one of them produces an error message: {{t1|{{#expr:1/0}}}} gives Template:T1.

Expression	Error message
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
Template:Xpd1
{{ `#expr:`{{ `x\|102\|1000`}} `18` }} gives {{#ifeq:TrainzOnline\|Meta\|{{#expr:Template:X18}}\|{{#expr:100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000*18}}}}
{{ `#expr:`{{ `x\|102\|1000`}} `179` }} gives {{#ifeq:TrainzOnline\|Meta\|{{#expr:Template:X179}}\|{{#expr:100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000*179}}}}
{{ `#expr:`{{ `x\|102\|1000`}} `180` }} gives {{#ifeq:TrainzOnline\|Meta\|{{#expr:Template:X180}}\|{{#expr:100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000100010001000*180}}}} ( "INF", but depending on the operating system of the server it may also be e.g. "1.#INF")
{{ `#expr:`{{ `x\|33\|(1+(`}} `1` {{ `x\|33\|))`}} }} gives {{#ifeq:TrainzOnline\|Meta\|{{#expr:Template:X1Template:X}}\|{{#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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))}}}}
{{ `#expr:`{{ `x\|34\|(1+(`}} `1` {{ `x\|34\|))`}} }} gives {{#ifeq:TrainzOnline\|Meta\|{{#expr:Template:X1Template:X}}\|{{#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))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))}}}}
`"{{{{#if:\|Template:Xpd/wl\|#expr:3.4.5.6}}}}"` gives "{{#expr:3.4.5.6}}" {{#ifeq:{{{gives}}}		}} [143] (no feature, only an oddity)

Note: Template:Links-small 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:

{{{#expr:2*3}}}	{{{#expr:2*3}}}	(triple braces, the whole is interpreted as parameter tag with parameter name "#expr:2*3")
{{#expr:2*3}}}	{{#expr:2*3}}}	(one closing brace too many; the last of the three is interpreted as plain text, so that the rest works fine)
{{{#expr:2*3}}	{{{#expr:2*3}}	(one opening brace too many; the first of the three is interpreted as plain text, so that the rest works fine)
{{#expr:2*3}	{{#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

{{ #expr: 2*{{ #ifexpr: 3*4>10|toolarge|3*4 }} }} gives

{{#expr:2*{{#ifexpr:3*4>10|toolarge|3*4}}}},

{{ #expr: 2*{{ #ifexpr: 3*4>10|too large|3*4 }} }} gives

{{#expr:2*{{#ifexpr:3*4>10|too large|3*4}}}}.

Minus sign

Only the ASCII hyphen (hyphen-minus) and minus signs work as minus signs; dashes are not permitted. The output, however, will always be in the form of a hyphen-minus:

hyphen-minus	Template:Xpd/wl\|#expr:-12}}}}"	"{{#expr:-12}}" {{#ifeq:	}} [144]
Unicode hyphen (U+2010, ‐)	`"{{#expr:‐12}}"`	"{{#expr:‐12}}"
minus sign produced by −	`"{{#expr:−12}}"`	"{{#expr:−12}}"
−	`"{{#expr:−12}}"`	"{{#expr:−12}}"
em dash produced by —	`"{{#expr:—12}}"`	"{{#expr:—12}}"
—	`"{{#expr:—12}}"`	"{{#expr:—12}}"
en dash produced by –	`"{{#expr:–12}}"`	"{{#expr:–12}}"
–	`"{{#expr:–12}}"`	"{{#expr:–12}}"

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 WP: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{{#if:23

|×10^{{{#switch:{{{2}}}
 |#default={{#switch:{{#if:23|{{#ifeq:23|{{#if:{{#ifexpr:{{#expr:23}}}}|(23)|{{#expr:23}}}}|true|{{#ifeq:23|+{{#if:{{#ifexpr:{{#expr:23}}}}|(23)|{{#expr:23}}}}|true|{{#ifeq:23|({{#if:{{#ifexpr:{{#expr:23}}}}|(23)|{{#expr:23}}}})|true|false}}}}}}}}
  |#default={{#switch:{{{2}}}
   |plus=+{{#ifexpr:(231)=(23)|Template:FormattingError|{{#ifexpr:23<0|−}}{{#ifexpr:abs(231)>10*abs(23)|{{#expr:abs(23)}}|{{#expr:trunc(abs(23))}}.{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>14|Template:FormattingError|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=1|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E1mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=2|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E2mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=3|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E3mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=4|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>4|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E4mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=5|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E5mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=6|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E6mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=7|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>7|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E7mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=8|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E8mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=9|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E9mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=10|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>10|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E10mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=11|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E11mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=12|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E12mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=13|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>13|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E13mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=14|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E14mod10}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}
   |#default={{#ifexpr:(231)=(23)|Template:FormattingError|{{#ifexpr:23<0|−}}{{#ifexpr:abs(231)>10*abs(23)|{{#expr:abs(23)}}|{{#expr:trunc(abs(23))}}.{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>14|Template:FormattingError|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=1|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E1mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=2|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E2mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=3|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E3mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=4|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>4|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E4mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=5|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E5mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=6|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E6mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=7|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>7|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E7mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=8|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E8mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=9|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E9mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=10|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>10|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E10mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=11|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E11mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=12|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E12mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=13|{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>13|}}{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E13mod10}}{{#ifexpr:{{#expr:(-ln(abs(231)-abs(23))/ln10round 0)-1}}>=14|{{#expr:{{#expr:abs(231)-trunc(abs(231))}}*1E14mod10}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}}
  }}
  |false=23
 }}
 |text=23
}}}
|^e

}}

Examples:

"{{{{#if:|Template:Xpd/wl|#expr:three}}}}" gives "{{#expr:three}}" {{#ifeq:{{{gives}}}||||||}} [145]
"{{{{#if:|Template:Xpd/wl|#expr:2<3}}}}" gives "{{#expr:2<3}}" {{#ifeq:{{{gives}}}||||||}} [146]
"{{{{#if:|Template:Xpd/wl|#expr:2≤3}}}}" gives "{{#expr:2≤3}}" {{#ifeq:{{{gives}}}||||||}} [147]
"{{{{#if:|Template:Xpd/wl|#expr:2<=3}}}}" gives "{{#expr:2<=3}}" {{#ifeq:{{{gives}}}||||||}} [148]
"{{{{#if:|Template:Xpd/wl|#expr:2>3}}}}" gives "{{#expr:2>3}}" {{#ifeq:{{{gives}}}||||||}} [149]
"{{{{#if:|Template:Xpd/wl|#expr:2≥3}}}}" gives "{{#expr:2≥3}}" {{#ifeq:{{{gives}}}||||||}} [150]
"{{{{#if:|Template:Xpd/wl|#expr:2>=3}}}}" gives "{{#expr:2>=3}}" {{#ifeq:{{{gives}}}||||||}} [151]
"{{{{#if:|Template:Xpd/wl|#expr:2*3}}}}" gives "{{#expr:2*3}}" {{#ifeq:{{{gives}}}||||||}} [152]
"{{{{#if:|Template:Xpd/wl|#expr:2×3}}}}" gives "{{#expr:2×3}}" {{#ifeq:{{{gives}}}||||||}} [153]
"{{{{#if:|Template:Xpd/wl|#expr:2,300}}}}" gives "{{#expr:2,300}}" {{#ifeq:{{{gives}}}||||||}} [154]
"{{{{#if:|Template:Xpd/wl|#expr:6E23}}}}" gives "{{#expr:6E23}}" {{#ifeq:{{{gives}}}||||||}} [155]

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.

Tactics for handling extreme numbers

In the digital storage of numbers, the effects of truncation error on numeric precision might cause some extreme decimal numbers (above 1E13 or below 1E-12), or other E-notation numbers, to mismatch during comparisons. There are some tactics which can help, such as comparing results with "#ifeq" rather than "#ifexpr".

Comparing large numbers

The floor function might mismatch the original value of a large number, by a tiny amount, and so comparisons can be made with #ifeq between separate expressions. For example:

{{#ifexpr: floor( 1.36E4 ) = 1.36E4|Equal|Differ}} gives "{{#ifexpr: floor( 1.36E4 ) = 1.36E4|Equal|Differ}}"
{{#ifexpr: floor( 1.33E4 ) = 1.33E4|Equal|Differ}} gives "{{#ifexpr: floor( 1.33E4 ) = 1.33E4|Equal|Differ}}"
{{#ifexpr: floor( 1.52E4 ) = 1.52E4|Equal|Differ}} gives "{{#ifexpr: floor( 1.52E4 ) = 1.52E4|Equal|Differ}}"
{{#ifexpr: floor( 1.36E13 ) = 1.36E13|Equal|Differ}} gives "{{#ifexpr: floor( 1.36E13 ) = 1.36E13|Equal|Differ}}"
{{#ifexpr: trunc( 1.36E13 ) = 1.36E13|Equal|Differ}} gives "{{#ifexpr: trunc( 1.36E13 ) = 1.36E13|Equal|Differ}}"

However, using #ifeq to compare the results of 2 expressions can work:

{{#ifeq: {{#expr:floor(1.33E4) }} | {{#expr:1.33E4}}|Equal|Differ}} gives "{{#ifeq: {{#expr:floor(1.33E4) }} | {{#expr:1.33E4}}|Equal|Differ}}"
{{#ifeq: {{#expr:floor(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}} gives "{{#ifeq: {{#expr:floor(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}}"
{{#ifeq: {{#expr:trunc(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}} gives "{{#ifeq: {{#expr:trunc(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}}"

The truncation-error amount can usually be displayed by subtraction:

{{#expr: floor(1.36E4) - 1.36E4 }} gives "{{#expr: floor(1.36E4) - 1.36E4 }}"
{{#expr: floor(13600) - 13600 }} gives "{{#expr: floor(13600) - 13600 }}"
{{#expr: floor(1.36E13) - 1.36E13 }} gives "{{#expr: floor(1.36E13) - 1.36E13 }}"
{{#expr: trunc(1.36E13) - 1.36E13 }} gives "{{#expr: trunc(1.36E13) - 1.36E13 }}"

There are similar workarounds to bypass other limitations due to truncation error in the handling of extreme numbers.

#switch form	#ifeq form
{{`{{{1n}}}`}}`}}{{#ifeq:+\|-\|\|-1=okay\|fail\|\|{{#ifeq:fail\|fail\|\|-1=okay\|fail\|{{#ifeq:-1=okay\|-1=okay\|\|-1=okay\|}}}}}}`}} </td><td> {{#ifeq:-\|+\|{{#switch:-1.0\|-1=okay\|fail\|}}\|{{#ifeq:fail\|fail\|{{#switch:-1.0\|-1=okay\|fail}}\|{{#ifeq:-1=okay\|-1=okay\|{{#switch:-1.0\|-1=okay}}\|{{#switch:-1.0}}}}}}}}	{{`{{{1n}}}`}}`}}{{#ifeq:fail\|fail\|\|-1\|okay\|fail\|{{#ifeq:okay\|okay\|\|-1\|okay\|{{#ifeq:-1\|-1\|\|-1\|}}}}}}`}} </td><td> {{#ifeq:fail\|fail\|{{#ifeq:-1.0\|-1\|okay\|fail}}\|{{#ifeq:okay\|okay\|{{#ifeq:-1.0\|-1\|okay}}\|{{#ifeq:-1\|-1\|{{#ifeq:-1.0\|-1}}\|{{#ifeq:-1.0}}}}}}}}
-1=okay\|fail}}"
{{`{{{1n}}}`}}`}}{{#ifeq:+\|-\|\|a=b=okay\|fail\|\|{{#ifeq:fail\|fail\|\|a=b=okay\|fail\|{{#ifeq:a=b=okay\|a=b=okay\|\|a=b=okay\|}}}}}}`}} </td><td> {{#ifeq:-\|+\|{{#switch:a=b\|a=b=okay\|fail\|}}\|{{#ifeq:fail\|fail\|{{#switch:a=b\|a=b=okay\|fail}}\|{{#ifeq:a=b=okay\|a=b=okay\|{{#switch:a=b\|a=b=okay}}\|{{#switch:a=b}}}}}}}}	{{`{{{1n}}}`}}`}}{{#ifeq:fail\|fail\|\|a=b\|okay\|fail\|{{#ifeq:okay\|okay\|\|a=b\|okay\|{{#ifeq:a=b\|a=b\|\|a=b\|}}}}}}`}} </td><td> {{#ifeq:fail\|fail\|{{#ifeq:a=b\|a=b\|okay\|fail}}\|{{#ifeq:okay\|okay\|{{#ifeq:a=b\|a=b\|okay}}\|{{#ifeq:a=b\|a=b\|{{#ifeq:a=b\|a=b}}\|{{#ifeq:a=b}}}}}}}}
{{`{{{1n}}}`}}`}}{{#ifeq:+\|-\|\|a=b=fail\|okay\|\|{{#ifeq:okay\|okay\|\|a=b=fail\|okay\|{{#ifeq:a=b=fail\|a=b=fail\|\|a=b=fail\|}}}}}}`}} </td><td> {{#ifeq:-\|+\|{{#switch:a=c\|a=b=fail\|okay\|}}\|{{#ifeq:okay\|okay\|{{#switch:a=c\|a=b=fail\|okay}}\|{{#ifeq:a=b=fail\|a=b=fail\|{{#switch:a=c\|a=b=fail}}\|{{#switch:a=c}}}}}}}}	{{`{{{1n}}}`}}`}}{{#ifeq:okay\|okay\|\|a=b\|fail\|okay\|{{#ifeq:fail\|fail\|\|a=b\|fail\|{{#ifeq:a=b\|a=b\|\|a=b\|}}}}}}`}} </td><td> {{#ifeq:okay\|okay\|{{#ifeq:a=c\|a=b\|fail\|okay}}\|{{#ifeq:fail\|fail\|{{#ifeq:a=c\|a=b\|fail}}\|{{#ifeq:a=b\|a=b\|{{#ifeq:a=c\|a=b}}\|{{#ifeq:a=c}}}}}}}}

Help:Calculation

Revision as of 21:35, 2 July 2013

Contents

Operators

Numbers as input

Numbers as output

Accuracy

Branching depending on an expression

Comparisons

Length of expressions

Error messages

Minus sign

Displaying numbers and numeric expressions

Tactics for handling extreme numbers

See also

Views

Personal tools

Navigation

Search

Toolbox

@@ Line 1: / Line 1: @@
-{{h:h|editor toc}}
+:''The accuracy and format of numeric results varies with the server; even on a single page, while for any rendering there is consistency within the page, there is no consistency among renderings.''
-:''The accuracy and format of numeric results varies with the server. Currently the results produced by Wikimedia servers seem to be uniform.''
+The MediaWiki extension [[mw:ParserFunctions|ParserFunctions]] enables users to perform [[meta:Help:Calculation|calculations]], for simple arithmetic or for functions as on a [[scientific calculator]], with rounding, floor, [[logarithm]]s (<code>ln</code>), [[sine]], [[cosine]], or [[modulo]] (etc.), plus boolean comparisons with "=" or "<" or ">=" etc.
-The functions #expr: and #ifexpr: of MediaWiki extension [[mw:Extension:ParserFunctions|ParserFunctions]] evaluate numerical [[w:Expression (programming)|expressions]], and also boolean expressions involving numbers and booleans (not strings). The syntax is
+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'' }}
+:<nowiki>{{</nowiki> #expr: ''expression'' }} &nbsp; - Spaces are not required, but spaces/commas within numbers are not allowed.
-Spaces are not needed, except between words (for operators and constants). Inside numbers no spaces are allowed.
+The supported operators (roughly in order of precedence) are:&nbsp;
+'''<tt>not</tt>''', '''<tt>^</tt>''',
+'''<tt>*</tt>''', '''<tt>/</tt>''', '''<tt>div</tt>''', '''<tt>mod</tt>''',
+'''<tt>+</tt>''', '''<tt>-</tt>''',
+'''<tt>round</tt>''', '''<tt>trunc</tt>''',
+'''<tt>=</tt>''', '''<tt>&lt;&gt;</tt>''', '''<tt>!=</tt>''', '''<tt>&lt;=</tt>''', '''<tt>&gt;=</tt>''',
+'''<tt>and</tt>''', and
+'''<tt>or</tt>'''. Functions include: <code>'''abs(&nbsp;), ceil(&nbsp;), floor(&nbsp;), [[natural logarithm|<font color=black>ln</font>]](&nbsp;), sin(&nbsp;), cos(&nbsp;), tan(&nbsp;)''',</code> etc.
-==General==
+The precision supports 14-digit numbers ([[pi]]: {{#expr:pi}}, or longer on some servers) and E-notation ("1.54E17"), but [[truncation error]] can cause mismatches on comparisons of very large numbers or tiny decimals, so see below: "[[#Tactics for handling extreme numbers|Tactics for handling extreme numbers]]".
-An expression is a string representing a [[w:tree structure|tree structure]] with [[w:Data type|type]]/[[w:Value (computer science)|value]] pairs as nodes, with [[w:Binary operation|binary operators]] in [[w:Infix notation|infix notation]], [[w:Unary operation|unary operators]] in [[w:Polish notation|prefix notation]], and end nodes represented by numbers and constants. Letters in operators and names of constants are case-insensitive.
-The ParserFunctions software determines which operators and constants, and what numbers, are supported. The e in scientific notation and the sign of a number are treated as operators, the supported literal numbers are unsigned numbers in ordinary decimal format. The ParserFunctions software also determines the precedence of the operators and the error messages, and it converts all literal numbers to type float.
+== Operators ==
-For the rest the ParserFunctions software just defines the operators in terms of [[w:PHP|PHP]] functions and operators, and any type conversions and pecularities of the operators are properties of these PHP functions and operators themselves. Also, the format of the result is entirely determined by PHP.
-The data types are the PHP data types [http://www.php.net/manual/en/language.types.float.php float] ([[w:Double precision floating-point format|double precision floating-point format]]) and [http://www.php.net/manual/en/language.types.integer.php integer] (64-bit [[w:Integer_(computer_science)|integer]]). The range for type integer is from -(2^63) = {{formatnum:{{#expr:trunc(1-2^63)}}}} through 2^63 - 1 = {{formatnum:{{#expr:(trunc2)^(trunc62)+((trunc2)^(trunc62)-(trunc1))}}}}. Type float allows fractions and very large  numbers, but only in the range -(2^52) = {{formatnum:{{#expr:trunc-(2^52)}}}} through (2^52) = {{formatnum:{{#expr:trunc(2^52)}}}} all integer values can be exactly represented in type float (see [[Help:Calculation accuracy]]).
-[[w:Type_system#Dynamic_typing|Dynamic typing]] is applied. The end nodes are all of type float (as mentioned, numbers are converted to float; this applies even for numbers with an integer value and format). The data type of the result of an operation depends on the operator, and for some operators on the type(s) of the argument(s), and in some cases on their value(s). If according to these rules the result is of type float,  any argument of type integer is converted to float before the operation, and the result is also rounded to float:
-*{{xpsoc|numfh|(trunc2^trunc62+trunc512)-2^62}}
-*{{xpsoc|numfh|(trunc2^trunc62+trunc512)+(trunc2^trunc62+trunc1535)}}
-*{{xpsoc|numfh|2^63+2047}}
-Apart from that, a numerical value outside the range of type integer is converted to float, except in the case of trunc (and mod, which involves applying trunc to the arguments first).
-There are 31 operators (excluding two synonyms), two constants, and the unsigned numbers in ordinary decimal notation.
-== Operators, numbers, and constants ==
-Since literal numbers are of type float, trunc is sometimes used in the examples to construct an integer-type argument, to demonstrate the result of an operator for this case.
-{| class="wikitable sortable"
-! ''Operator''
-! ''<abbr title="number of arguments">Args</abbr>''
-! ''Operation''
-! ''PHP''
-! ''Data type''
-! ''<abbr title="Precedence">Prio</abbr>''
-! ''Examples''
-|-
-| <code>'''-'''</code> || 1
-| [[w:Unary operation#Unary negative and positive|unary '''<tt>-</tt><code>''' sign]]  (negation)
-| [http://php.net/manual/en/language.operators.arithmetic.php -] || same as argument|| {{nts|10}} ||
 {| class="wikitable"
-{{xpettu|-|12}}
+! Operator
-{{xpettu|-|trunc12}}
+! Operation
-{{xpettu|-|trunc(-2^63)}}
+! Examples
-|}
 |-
-| '''<code>e<code>''' between subexpressions|| 2 || *10^ || [http://php.net/manual/en/language.operators.arithmetic.php *] [http://php.net/manual/en/function.pow.php pow] (10,..) || float unless the factor on the left is of type integer and the exponent is non-negative and of type integer || {{nts|10}}
+| none|| none
 |
 {| class="wikitable"
-{{xpettb|2|e|3}}
+|{{xpd0|#expr:123456789012345|gives={{!}}{{!}}}}
-{{xpettb|-2.3|e|-4}}
+|-
-{{xpettb|(trunc2)|e|(trunc-3)}}
+|{{xpd0|#expr:1.23456789012345|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|e|(trunc0)}}
+|-
-{{xpettb|(trunc2)|e|(trunc18)}}
+|{{xpd0|#expr:.000001|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|e|(trunc19)}}
+|-
-{{xpett|6e(5-2)e-2}}
+|{{xpd0|#expr:.00000123456789012345|gives={{!}}{{!}}}}
-{{xpett|1e.5}}
+|-
+|{{xpd0|#expr:.123e4|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:123E-2|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:e|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:pi|gives={{!}}{{!}}}}
 |}
 Wrong:
 {| class="wikitable"
-|{{xpett|e4}}
+|{{xpd0|#expr:e4|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>exp<code>''' || 1
+! exp
-| [[w:Exponential function|exponential function e<sup>x</sup>]]
+| [[E_(mathematical_constant)|e]] to the specified power
-| [http://php.net/manual/en/function.exp.php exp] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|exp|43}}
+|{{xpd0|#expr:exp1.2|gives={{!}}{{!}}}}
-{{xpettu|exp| trunc0}}
-{{xpettu|exp|709}}
-{{xpettu|exp|-744}}
 |}
 Compare:
 {| class="wikitable"
-|{{xpett|e^43}}
+|{{xpd0|#expr:e^1.2|gives={{!}}{{!}}}}
-|-
-|{{xpett|trunc exp43}}
 |}
 |-
-| '''<code>ln<code>''' || 1
+! ln
-| [[w:Natural logarithm|natural logarithm]]
+| Natural logarithm
-| [http://php.net/manual/en/function.log.php <sup>log</sup>] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|ln|2}}
+|{{xpd0|#expr:ln2|gives={{!}}{{!}}}}
-{{xpettu|ln| trunc1}}
-{{xpettu|ln|8.9e307}}
-{{xpettu|ln|.5e-323}}
 |}
-Hence, the common logarithm of e.g. 2:
+Hence, the base ten logarithm of e.g. 2:
 {| class="wikitable"
-|{{xpett|ln2/ln10}}
+|{{xpd0|#expr:ln2/ln10|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>abs<code>''' || 1
+! abs
-| [[w:Absolute value|absolute value]]
+|
-| [http://php.net/manual/en/function.abs.php abs] || same as argument || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|abs|-2}}
+|{{xpd0|#expr:abs-1.2|gives={{!}}{{!}}}}
-{{xpettu|abs| trunc-2}}
-{{xpettu|abs| trunc-2^63}}
 |}
 |-
-| '''<code>trunc<code>''' || 1
+! trunc
-| [[w:Truncation|truncation]]
+|
-| [http://php.net/manual/en/language.types.integer.php#language.types.integer.casting (int)], i.e. [[w:Type conversion|type-casting]] to integer || integer || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|trunc|1.2}}
+|{{xpd0|#expr:trunc1.2|gives={{!}}{{!}}}}
-{{xpettu|trunc|1.8}}
+|-
-{{xpettu|trunc|-1.2}}
+|{{xpd0|#expr:trunc-1.2|gives={{!}}{{!}}}}
-{{xpettu|trunc|(-2^64+1e5)}}
-{{xpettu|trunc|(-2^63+1e5)}}
-{{xpettu|trunc|(2^63)}}
-{{xpettu|trunc|(2^63+1e5)}}
-{{xpettu|trunc|(2^64+1e5)}}
 |}
 |-
-| '''<code>floor<code>''' || 1
+! floor
-| [[w:Floor function|floor function]]
+|
-| [http://php.net/manual/en/function.floor.php floor] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|floor|1.2}}
+|{{xpd0|#expr:floor1.2|gives={{!}}{{!}}}}
-{{xpettu|floor|-1.2}}
+|-
-{{xpettu|floor| trunc3}}
+|{{xpd0|#expr:floor-1.2|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>ceil<code>''' || 1
+! ceil
-| [[w:Ceiling function|ceiling function]]
+|
-| [http://php.net/manual/en/function.ceil.php ceil] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|ceil|1.2}}
+|{{xpd0|#expr:ceil1.2|gives={{!}}{{!}}}}
-{{xpettu|ceil|-1.2}}
+|-
-{{xpettu|ceil| trunc3}}
+|{{xpd0|#expr:ceil-1.2|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>sin<code>''' || 1
+! sin
-| [[w:Sine function|sine]]
+|
-| [http://php.net/manual/en/function.sin.php sin] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|sin|.1}}
+|{{xpd0|#expr:sin.1|gives={{!}}{{!}}}}
-{{xpettu|sin| trunc1}}
 |}
 With an angle in degrees, e.g. 30°:
 {| class="wikitable"
-|{{xpett|sin(30*pi/180)}}
+|{{xpd0|#expr:sin(30*pi/180)|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>cos<code>''' || 1
+! cos
-| [[w:Cosine function|cosine]]
+|
-| [http://php.net/manual/en/function.cos.php cos] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|cos|.1}}
+|{{xpd0|#expr:cos.1|gives={{!}}{{!}}}}
-{{xpettu|cos| trunc1}}
 |}
 |-
-| '''<code>tan<code>''' || 1
+! tan
-| [[w:Tangent function|tangent]]
+|
-| [http://php.net/manual/en/function.tan.php tan] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|tan|.1}}
+|{{xpd0|#expr:tan.1|gives={{!}}{{!}}}}
-{{xpettu|tan| trunc1}}
 |}
 |-
-| '''<code>asin<code>''' || 1
+! asin
-| [[w:Arcsine|arcsine]]
+|
-| [http://php.net/manual/en/function.asin.php asin] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|asin|.1}}
+|{{xpd0|#expr:asin.1|gives={{!}}{{!}}}}
-{{xpettu|asin| trunc1}}
 |}
 |-
-| '''<code>acos<code>''' || 1
+! acos
-| [[w:Arccosine|arccosine]]
+|
-| [http://php.net/manual/en/function.acos.php acos] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|acos|.1}}
+|{{xpd0|#expr:acos.1|gives={{!}}{{!}}}}
-{{xpettu|acos| trunc1}}
-{{xpettu|2*|acos 0}}
 |}
 |-
-| '''<code>atan<code>''' || 1
+! atan
-| [[w:Arctangent|arctangent]]
+|
-| [http://php.net/manual/en/function.atan.php atan] || float || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|atan|.1}}
+|{{xpd0|#expr:atan.1|gives={{!}}{{!}}}}
-{{xpettu|atan| trunc1}}
-{{xpettu|4*|atan 1}}
 |}
 |-
-| '''<code>not<code>''' || 1
+! +
-| [[w:Negation|negation]], logical NOT
+| Unary '''<tt>+</tt>''' sign
-| [http://www.php.net/manual/en/language.operators.logical.php !] || integer (1 or 0) || {{nts|9}} ||
+|
 {| class="wikitable"
-{{xpettu|not|0}}
+|{{xpd0|#expr:+12|gives={{!}}{{!}}}}
-{{xpettu|not|1}}
+|-
-{{xpettu|not|2}}
+|{{xpd0|#expr:++12|gives={{!}}{{!}}}}
-{{xpettu|not| trunc1}}
+|-
+|{{xpd0|#expr:+-12|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>^<code>''' || 2
+! -
-| [[w:Exponentiation|exponentiation]] (power)
+| Unary '''<tt>-</tt>''' sign (negation)
-| [http://php.net/manual/en/function.pow.php pow] || float unless the base is of type integer and the exponent is non-negative and of type integer || {{nts|8}} ||
+|
 {| class="wikitable"
-{{xpettb|2|^|3}}
+|{{xpd0|#expr:-12|gives={{!}}{{!}}}}
-{{xpettb|-2|^|3}}
+|-
-{{xpettb|-2|^|4}}
+|{{xpd0|#expr:-+12|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|^|(trunc-3)}}
+|-
-{{xpettb|(trunc2)|^|(trunc0)}}
+|{{xpd0|#expr:--12|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|^|(trunc62)}}
-{{xpettb|(trunc2)|^|(trunc63)}}
-{{xpettb|(-2)|^|1.2}}
-{{xpettb|(-2)|^|.5}}
 |}
 |-
-| '''<code>*<code>''' || 2
+! not
-| [[w:Multiplication|multiplication]]
+| Unary NOT, logical NOT
-| [http://php.net/manual/en/language.operators.arithmetic.php *] || integer if both arguments are integer, otherwise float || {{nts|7}} ||
+|
 {| class="wikitable"
-{{xpettb|2|*|3}}
+|{{xpd0|#expr:not 0|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|*|3}}
+|-
-{{xpettb|2|*|trunc3}}
+|{{xpd0|#expr:not 1|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|*|trunc3}}
+|-
-{{xpettb|(trunc1e10)|*|trunc1e9}}
+|{{xpd0|#expr:not 2|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>/<code>''' (also written '''div''') || 2
+! ^
-|| [[w:Division (mathematics)|division]] (div is not integer division<ref name="divmod">'''<code>div</code>''' and '''<code>mod</code>''' are different from all programming languages, see [[bugzilla:6068]]</ref>)
+| Power
-| [http://php.net/manual/en/language.operators.arithmetic.php /] || float, unless both arguments are integer and the mathematical result is an integer || {{nts|7}} ||
+|
 {| class="wikitable"
-{{xpettb|6|/|3}}
+|{{xpd0|#expr:2^7|gives={{!}}{{!}}}}
-{{xpettb|(trunc6)|/|3}}
+|-
-{{xpettb|2|/|trunc6}}
+|{{xpd0|#expr:2^-7|gives={{!}}{{!}}}}
-{{xpettb|(trunc6)|/|trunc3}}
+|-
-{{xpettb|(trunc6)|/|trunc4}}
+|{{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={{!}}{{!}}}}
 |}
 |-
-| '''<code>mod<code>''' || 2
+! *
-| [[w:Modulo operation|modulo]] operation,&#160;remainder&#160;of&#160;division after truncating both operands to an integer.<ref name="divmod"/>
+| Multiplication
-| [http://php.net/manual/en/language.operators.arithmetic.php %] || integer || {{nts|7}} ||
+|
 {| class="wikitable"
-{{xpettb|30|mod|7}}
+|{{xpd0|#expr:30*7|gives={{!}}{{!}}}}
-{{xpettb|-30|mod|7}}
+|-
-{{xpettb|30|mod|-7}}
+|{{xpd0|#expr:30*-7|gives={{!}}{{!}}}}
-{{xpettb|-30|mod|-7}}
-{{xpettb|30.5|mod|7.9}}
 |}
 |-
-| '''<code>+</code>''' || 2
+! /
-|| [[w:Addition|addition]]
+|| Division, same as '''div'''
-| [http://php.net/manual/en/language.operators.arithmetic.php +] || integer if both arguments are integer, otherwise float || {{nts|6}} ||
+|
 {| class="wikitable"
-{{xpettb|2|+|3}}
+|{{xpd0|#expr:30/7|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|+|3}}
+|-
-{{xpettb|2|+|trunc3}}
+|{{xpd0|#expr:30/-7|gives={{!}}{{!}}}}
-{{xpettb|(trunc2)|+|trunc3}}
-{{xpettb|(trunc7e18)|+|trunc4e18}}
 |}
 |-
-| '''<code>-</code>''' || 2
+! [[w:en:Division_%28mathematics%29#Division_of_integers|div]]
-|| [[w:Subtraction|subtraction]]
+|| Division, same as '''/''',<br />not integer division
-| [http://php.net/manual/en/language.operators.arithmetic.php -] || integer if both arguments are integer, otherwise float || {{nts|6}} ||
+|
 {| class="wikitable"
-{{xpettb|3|-|2}}
+|{{xpd0|#expr:30 div 7|gives={{!}}{{!}}}} (should be 4)
-{{xpettb|(trunc3)|-|2}}
-{{xpettb|2|-|trunc2}}
-{{xpettb|(trunc3)|-|trunc2}}
-{{xpettb|(trunc-7e18)|-|trunc4e18}}
 |}
 |-
-| '''<code>round<code>''' || 2
+! [[w:en:Modulo operation|mod]]
-|| [[w:rounding|rounds off]] the number on the left to a multiple of 1/10 raised to a power, with the exponent equal to the truncated value of the number given on the right
+|"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]].
-| [http://php.net/manual/en/function.round.php round] || float || {{nts|5}} ||
+|
 {| class="wikitable"
-{{xpettb|9.876|round|2}}
+|{{xpd0|#expr:30 mod 7|gives={{!}}{{!}}}}
-{{xpettb|(trunc1234)|round| trunc-2}}
+|-
-{{xpettb|4.5|round|0}}
+|{{xpd0|#expr:30 mod -7|gives={{!}}{{!}}}}
-{{xpettb|-4.5|round|0}}
+|-
-{{xpettb|46.857|round|1.8}}
+|{{xpd0|#expr:-30 mod 7|gives={{!}}{{!}}}}
-{{xpettb|46.857|round|-1.8}}
+|-
+|{{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)
 |}
 |-
-| '''<code>=<code>''' || 2
+! <tt>+</tt>
-|| [[w:Equality (mathematics)|equality]] (numerical incl. logical, not for strings)
+|| Addition
-| [http://php.net/manual/en/language.operators.comparison.php ==] || integer (1 or 0) || {{nts|4}} ||
+|
 {| class="wikitable"
-{{xpettb|3.0|{{=}}|3}}
+|{{xpd0|#expr:30 + 7|gives={{!}}{{!}}}}
-{{xpettb|3.1|{{=}}|3}}
-{{xpettb|3.0|{{=}}|trunc3}}
-{{xpettb|3.1|{{=}}|trunc3}}
-{{xpettb|1e16|{{=}}|trunc(1e16)}}
-{{xpettb|1e16|{{=}}|trunc(1e16)+trunc1}}
-{{xpettb|trunc(1e16)|{{=}}|trunc(1e16)+trunc1}}
-|}
-wrong:
-{| class="wikitable"
-|{{xpett|a{{=}}a}}
 |}
 |-
-| '''<code>&lt;&gt;<code>''' (also written '''!=''') || 2
+! <tt>-</tt>
-| [[w:Inequality|inequality]], logical ''xor'';  not for strings  (negation of =)
+|| Subtraction
-| [http://php.net/manual/en/language.operators.comparison.php !=] || integer (1 or 0) || {{nts|4}} ||
+|
 {| class="wikitable"
-{{xpettb|3|<>|3}}
+|{{xpd0|#expr:30 - 7|gives={{!}}{{!}}}}
-{{xpettb|3|<>|4}}
 |}
 |-
-| '''<code>&lt;<code>''' || 2
+! round
-|| [[w:Inequality (mathematics)|less than]] (not for ordering of strings)
+|| 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])
-| [http://php.net/manual/en/language.operators.comparison.php <] || integer (1 or 0) || {{nts|4}} ||
+|
 {| class="wikitable"
-{{xpettb|3|<|3}}
+|{{xpd0|#expr:4.2857 round 3|gives={{!}}{{!}}}}
-{{xpettb|3|<|4}}
+|-
-{{xpettb|2.9|<|3}}
+|{{xpd0|#expr:4.2857 round 0|gives={{!}}{{!}}}}
-{{xpettb|3.0|<|3}}
+|-
-{{xpettb|2.9|<|trunc3}}
+|{{xpd0|#expr:42857 round -2|gives={{!}}{{!}}}}
-{{xpettb|3.0|<|trunc3}}
+|-
-{{xpettb|1e16|<|trunc(1e16)+trunc1}}
+|{{xpd0|#expr:4.5 round 0|gives={{!}}{{!}}}}
-|}
+|-
+|{{xpd0|#expr:-4.5 round 0|gives={{!}}{{!}}}}
-wrong:
-{| class="wikitable"
-{{xpettb|a|<|b}}
 |}
 |-
-| '''<code>&gt;<code>''' || 2
+! =
-|| [[w:Inequality (mathematics)|greater than]] (same as <, with arguments reversed)
+|| Equality (numerical incl. logical)
-| [http://php.net/manual/en/language.operators.comparison.php >] || integer (1 or 0) || {{nts|4}} ||
+|
 {| class="wikitable"
-{{xpettb|4|>|3}}
+|{{xpd0|#expr:3{{=}}03.0|gives={{!}}{{!}}}}
-{{xpettb|3|>|3}}
 |}
 |-
-| '''<code>&lt;=<code>''' || 2
+! &lt;&gt;
-| [[w:Inequality (mathematics)|less than or equal to]] (same as >=, with arguments reversed)
+| Inequality, same as '''!='''
-| [http://php.net/manual/en/language.operators.comparison.php <=] || integer (1 or 0) || {{nts|4}} ||
+|
 {| class="wikitable"
-{{xpettb|3|<{{=}}|4}}
+|{{xpd0|#expr:3<>03.0|gives={{!}}{{!}}}}
-{{xpettb|3|<{{=}}|3}}
+|-
+|{{xpd0|#expr:3<>4|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>&gt;=<code>''' || 2
+!| !=
-| [[w:Inequality (mathematics)|greater than or equal to]] (negation of <)
+|| Inequality, same as '''&lt;&gt;''', logical ''xor''
-| [http://php.net/manual/en/language.operators.logical.php >=] || integer (1 or 0) || {{nts|4}} ||
+|
 {| class="wikitable"
-{{xpettb|4|>{{=}}|3}}
+|{{xpd0|#expr:3!{{=}}03.0|gives={{!}}{{!}}}}
-{{xpettb|3|>{{=}}|3}}
+|-
+|{{xpd0|#expr:3!{{=}}4|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>and<code>''' || 2
+! &lt;
-| [[w:Logical conjunction|logical AND]]
+|| Less than
-| [http://php.net/manual/en/language.operators.logical.php &&] || integer (1 or 0) || {{nts|3}} ||
+|
 {| class="wikitable"
-{{xpettb|3|and|4}}
+|{{xpd0|#expr:3<2|gives={{!}}{{!}}}}
-{{xpettb|-3|and|0}}
+|-
-{{xpettb|0|and|4}}
+|{{xpd0|#expr:3<3|gives={{!}}{{!}}}}
-{{xpettb|0|and|0}}
+|-
+|{{xpd0|#expr:3<4|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>or<code>''' || 2
+! &gt;
-| [[w:Logical disjunction|logical OR]]
+|| Greater than
-| [http://php.net/manual/en/language.operators.logical.php <nowiki>||</nowiki>] || integer (1 or 0) || {{nts|2}} ||
+|
 {| class="wikitable"
-{{xpettb|3|or|4}}
+|{{xpd0|#expr:3>2|gives={{!}}{{!}}}}
-{{xpettb|-3|or|0}}
+|-
-{{xpettb|0|or|4}}
+|{{xpd0|#expr:3>3|gives={{!}}{{!}}}}
-{{xpettb|0|or|0}}
+|-
+|{{xpd0|#expr:3>4|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>+<code>''' || 1
+! &lt;=
-| [[w:Unary operation#Unary negative and positive|unary '''<tt>+</tt><code>''' sign]]
+| Less than or equal to
-| (nothing) || same as argument || n.a. ||
+|
 {| class="wikitable"
-{{xpettu|+|1}}
+|{{xpd0|#expr:3<{{=}}2|gives={{!}}{{!}}}}
-{{xpettu|+|-1}}
+|-
-{{xpettu|+|trunc1}}
+|{{xpd0|#expr:3<{{=}}3|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:3<{{=}}4|gives={{!}}{{!}}}}
 |}
 |-
-| (number) || 0
+! &gt;=
-| unsigned number in ordinary decimal notation (unary plus and minus and e are treated as operators, see elsewhere in this table) || [http://nl.php.net/manual/en/function.floatval.php floatval] || float || n.a.
+| Greater than or equal to
 |
 {| class="wikitable"
-| {{xpett|1234567890123456789}}
+|{{xpd0|#expr:3>{{=}}2|gives={{!}}{{!}}}}
 |-
-| {{xpett|123456789.0123456789}}
+|{{xpd0|#expr:3>{{=}}3|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:3>{{=}}4|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>e<code>''' as subexpression || 0
+! and
-| constant [[w:e (mathematical constant)|e]] || [http://php.net/manual/en/function.exp.php exp](1) || float || n.a.
+| Logical AND
 |
 {| class="wikitable"
-| {{xpett|e}}
+|{{xpd0|#expr:3 and 4|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:0 and 3|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:-3 and 0|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:0 and 0|gives={{!}}{{!}}}}
 |}
 |-
-| '''<code>pi<code>''' || 0
+! or
-| constant [[w:pi|π]] || [http://php.net/manual/en/function.pi.php pi]() || float || n.a.
+| Logical OR
 |
 {| class="wikitable"
-| {{xpett|pi}}
+|{{xpd0|#expr:3 or 4|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:0 or 3|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:-3 or 0|gives={{!}}{{!}}}}
+|-
+|{{xpd0|#expr:0 or 0|gives={{!}}{{!}}}}
 |}
 |}
-Logical operators return 1 for true and 0 for false, and interpret 0 as false and any other number as true. Thus {{xpd0|d=|#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.
+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 is indicated in the table, a higher number means that the operator is applied first. Examples (">" refers to going before, "~" means application from left to right):
-*e > floor, not, etc.: {{xpsoc|#expr:floor1.5e1}}, {{xpsoc|#expr:not0e1}}
-*floor > ^: {{xpsoc|#expr:floor1.5^2}}
-*^ > *: {{xpsoc|#expr:2*3^2}}
-*<nowiki>*</nowiki> ~ / ~ mod: {{xpsoc|#expr:12/3*2}}, {{xpsoc|#expr:111/3mod10}}, {{xpsoc|#expr:358mod10*2}},
-*<nowiki>*</nowiki> > +, -: {{xpsoc|#expr:2+3*4}}, {{xpsoc|#expr:2-3*4}}
-*+ ~ -: {{xpsoc|#expr:6-2+3}}, {{xpsoc|#expr:-2+3}}
-*+, - > round: {{xpsoc|#expr:1.234round2-1}}
-*round > = etc.: {{xpsoc|1=#expr:1.23=1.234round2}}
-*= etc. > and: {{xpsoc|1=#expr:1 and 2=1}}
-*and > or: {{xpsoc|1=#expr:1 or 1 and 0}}
-In the case of equal precedence number, evaluation is from left to right:
+Precedence:
-*{{xpsoc|#expr:12/2*3}}
+*{{xpd0|#expr: 2 - 3 + 4 / 5 * 6}}
-*{{xpsoc|#expr:3^3^3}}
-Parentheses can force a different precedence: {{xpsoc|#expr:(2+3)*4}}
+(+ and - have equal precedence, * and / also, both higher than the former two).
-Blank spaces are good for readability but not needed for working properly, except between words (including "e"), and not allowed within numbers:
+*{{xpd0|1=#expr: 2 = 5 < 3 + 4}}
-*{{xpd0|d=|#expr:7mod3}}
-*{{xpd0|d=|#expr:7.5round0}}
-*{{xpd0|d=|#expr:0and1}}
-*{{xpd0|d=|#expr:0or not0}}
-*{{xpd0|d=|#expr:0ornot0}}
-*{{xpd0|d=|#expr:123 456}}
-*{{xpd0|d=|#expr:not not3}}
-*{{xpd0|d=|#expr:notnot3}}
-*{{xpd0|d=|#expr:---2}}
+(first +, then =, then <).
-*{{xpd0|d=|#expr:-+-2}}
-*{{xpd0|d=|#expr:2*-3}}
-*{{xpd0|d=|#expr:-not-not-not0}}
-*{{xpd0|d=|#expr:2*/3}}
-*{{xpd0|d=|#expr:sinln1.1}}
-*{{xpd0|d=|#expr:sin ln1.1}}
-For scientific notation e is treated as an operator. An e between subexpressions works just like *10^, except that together with the unary minus, it has the highest precedence, e.g. before a separate ^, and that the implicit 10 is of type integer, not float. An e as subexpression (i.e., with an each side either nothing or an operator) is Euler's constant. An e with on one side nothing or an operator and on the other side a subexpression gives an error message.
+*{{xpd0|#expr:1.234 + 1.234 round 1 + 1 }}
-==Transitivity==
+(first additions, then round)
-For comparing a number of type float with one of type integer, the integer is converted to float. Therefore the operators =, <= and >= are not [[w:Transitive relation|transitive]] with mixed types:
-*{{xpsoc|1=#expr:trunc1e16=1e16}}
-*{{xpsoc|1=#expr:1e16=trunc1e16+trunc1}}
-*{{xpsoc|1=#expr:trunc1e16=trunc1e16+trunc1}}
-*{{xpsoc|1=#expr:trunc1e16>=1e16}}
+*{{xpd0|#expr:3 * 4 mod 10 * 10 }}
-*{{xpsoc|1=#expr:1e16>=trunc1e16+trunc1}}
-*{{xpsoc|1=#expr:trunc1e16>=trunc1e16+trunc1}}
-Similarly, a >= b and b = c does not imply a >=c:
+(mod and multiplication have equal precedence, evaluation from left to right)
-*{{xpsoc|1=#expr:trunc1e16>=1e16}}
-*{{xpsoc|1=#expr:1e16=trunc1e16+trunc1}}
-*{{xpsoc|1=#expr:trunc1e16>=trunc1e16+trunc1}}
-However, < and > ''are'' transitive.
+Parentheses can force a different precedence: {{xpd0|#expr: (2 + 3) * 4}}
-==Monotonicity==
+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:
-In division of numbers of type integer, a small change in the dividend can change the type of the result. Therefore, if the absolute value of the result is greater than 2^53, it is not always a [[w:Monotonic function|monotonic function]] of the dividend:
+*{{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}}
-*{{xpsoc|numf|(trunc1e18-trunc2)/trunc3}}
+*{{xpd0|#expr:---2}}
-*{{xpsoc|numf|(trunc1e18-trunc1)/trunc3}}
+*{{xpd0|#expr:-+-2}}
-*{{xpsoc|numf|trunc1e18/trunc3}}
+*{{xpd0|#expr:2*-3}}
+*{{xpd0|#expr:-not-not-not0}}
-[[Template:Divint]] rectifies this.
+*{{xpd0|#expr:2*/3}}
+*{{xpd0|#expr:sinln1.1}}
+*{{xpd0|#expr:sin ln1.1}}
 ==Numbers as input==
@@ Line 480: / Line 422: @@
 *{{xpd0|#expr: 12.}}
-These equivalences apply also for #ifeq and #switch, see below.
+These equivalences are also relevant for #ifeq and #switch, see below.
-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:
+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 a number can only consist of:
+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:
-* one or more digits, or
-* zero or more digits, a point, and zero or more digits.
-*{{xpd0|#expr:123}}
+Thus a number can only consist of one or more digits, or zero or more digits, a point, and zero or more digits. (For the purpose of evaluating an expression a plus or minus sign is considered a unary operator instead of part of the number.)
-*{{xpd0|#expr:123.456}}
-*{{xpd0|#expr:.456}}
-*{{xpd0|#expr:0}}
-Also accepted:
+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.4560 }}
+*{{xpd0|#expr: 000123}}
-*{{xpd0|#expr:.}}
+*{{xpd0|#expr: 123.456.789}}
+*{{xpd0|#expr: .}}
-With ignored part:
+*{{xpd0|#expr: 2e-5}}
-*{{xpd0|#expr:123.456.789}}
+*{{xpd0|#expr: 2E-5}}
+*{{xpd0|#expr: E}}
+*{{xpd0|#expr: e}}
+*{{xpd0|#expr: E-5}}
+*{{xpd0|#expr: e-5}}
+*{{xpd0|#expr: 1e-5}}
 Wrong:
 *{{xpd0|#expr: 123,456}}
 *{{xpd0|#expr: 123 456}}
-Combinations with the operator e:
+Due to the specifier R ("raw"), {{xpdoc|NUMBEROFARTICLES:R}} etc., i.e. numbers without group separators, which can be used in computations.
-Float:
-*{{xpd0|#expr:2.3e-5}}
-*{{xpsoc|#expr:2e18}}
-Integer type:
-*{{xpsoc|#expr:(trunc123456789012345)e trunc4}}
-Compare:
-*{{xpsoc|#expr:123456789012345e4}}
-*{{xpsoc|#expr:trunc123456789012345e4}}
-*{{xpsoc|#expr:(trunc123456789012345)e4}}
-*{{xpd0|#expr: e5}}
-Commas can be removed as follows:
-*{{xpsoc|formatnum:1,2,,34.567,8|R}}
-Input of a number of type integer is not possible. A float can be converted to type integer with the function trunc. An integer with a value that is not a float value can be constructed, e.g. with [[Template:Trunc]], where the number is given in two pieces:
-*{{xpsopocc|numf|trunc|12345678|90123456789}}
-The smallest positive float can be written:
-*{{xpsoc|#expr:.5e-323}}
-but we cannot use that output as input:
-*{{xpsoc|#expr:{{#expr:.5e-323}}}}
-All digits are used to determine the float to which a number is rounded, as demonstrated in a borderline case:
-<small>{{xpsoc|hex|0.00000000000000011102230246251566636831481088739149080825}}</small><br>
-<small>{{xpsoc|hex|0.00000000000000011102230246251566636831481088739149080826}}</small>
-*{{xpsoc|numf|2^-53}}
-*{{xpsoc|numf|2^-53+2^-105}}
-Similarly:
-*{{xpsoc|numfh|4398046511104.00048828125}}
-*{{xpsoc|numfh|4398046511104.00048828125000000000000000000000000000000000000000000000001}}
-*2^42+2^-10 = 4,398,046,511,104.000,976,562,5
-Thus we see that the value halfway the two consecutive floats is rounded down in this case, while the other decimal fractions between the two floats are rounded to the nearest of the two.
-===Function plural===
+As opposed to ParserFunctions, "[[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:
-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}}
@@ Line 555: / Line 475: @@
 == Numbers as output ==
-The MediaWiki software simply passes on the literal result of the php computation, except that logical values are changed to 1 and 0. Therefore the format can depend on the server.
+A non-integer result has a decimal point in it. Scientific notation is produced for numbers with small absolute value ( less than 1E-4) and for numbers with large absolute value ( greater than or equal to 1E+12; however, even within MediaWiki 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):
-A number of type integer is displayed without rounding and in ordinary decimal notation:
+*{{xpdoc|#expr: .000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000123456789012345}}
-*{{xpsoc|#expr:trunc(2^52)}}
+*{{xpdoc|#expr: .00000123456789012345}}
-*{{xpsoc|#expr:-trunc(2^52)}}
+*{{xpdoc|#expr: .0000123456789012345}}
-*{{xpsoc|#expr:trunc1100000}}
+*{{xpdoc|#expr: .000123456789012345}}
-*{{xpsoc|#expr:trunc1200000}}
+*{{xpdoc|#expr: 123456789012.345}}
-*{{xpsoc|#expr:trunc1300000}}
+*{{xpdoc|#expr: 1234567890123.45}}
-*{{xpsoc|#expr:trunc4100000}}
+*{{xpdoc|#expr: 12345678901234.5}}
-while a number of type float is rounded to 14 digits, while inconsistently displaying some numbers in scientific format. This is reportedly a bug in the [[w:Zend Engine|Zend Engine]] which has been fixed [http://bugs.php.net/43053], but on Wikimedia apparently not yet:
+*{{xpdoc|#expr: 123456789012345}}
-*{{xpsoc|#expr:2^52}}
+*{{xpdoc|#expr: 1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456}}
-*{{xpsoc|#expr:-(2^52)}}
+*{{xpdoc|#expr: 1.234e4}}
-*{{xpsoc|#expr:1100000}}
+*{{xpdoc|#expr: 1.234e-4}}
-*{{xpsoc|#expr:1200000}}
-*{{xpsoc|#expr:1300000}}
-*{{xpsoc|#expr:4100000}}
-*{{xpsoc|#expr:1/7}}
-For some representable round numbers, notably some multiples of 100,000,  scientific notation is produced, which, if reused in an expression, is not even exactly equal to the original number:
+For negative numbers simply a minus sign is prefixed:
-*{{xpsoc|numfh|4.1e6}}
+*{{xpdoc|#expr: -123456789012345}}
-Thus we may want to either compare two results of #expr (for equality up to 14 digits) or compare two expressions, such as 4100000 and 4000000+100000 (for exact equality); depending on context and intention, the negative result of the comparison of the result of expr with the exact number may be confusing.
-The function formatnum adds commas (on the left of the point only), but does not convert from or to scientific format:
+;Long <tt>YYYYMMDDhhmmss</tt> timestamps can run into the same problem:
+:{{xpdoc|CURRENTTIMESTAMP}},
+:{{xpdoocc|#expr:|CURRENTTIMESTAMP}}.
+;Timestamps without seconds are 12 digits, just short enough:
+:{{xpdoc|#expr:{{CURRENTTIMESTAMP}}/100}}
-*{{xpsoc|formatnum:1234567.890123}}
+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}}.
-*{{xpsoc|formatnum:1234567.890123E16}}
-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}}.
+Two methods for representing intermediate results are:
-[[Template:Num]] displays a number with high accuracy (such that in the case of float the specific internal value is reconstructed when using the output as input), with the variant [[Template:Numf]] showing thousands separators:
+. The expression resulting from processing the expressions themselves, using #expr for branching only.
-*{{xpsoc|numf|trunc3^trunc39}}
-*{{xpsoc|numf|trunc3^trunc40}}
-*{{xpsoc|numf|1/7}}
-==Negative zero==
+For example, {{tim|powe}} produces the power of a number in the form of an expression:
-Although the literal "-0" (the unary minus applied to 0) gives 0, some operations give the float "[[w:Signed zero|-0]]" (preserving commutativity of + and *):
+*{{xpd2|powe|31.18|12}}
-Generating -0 with <code>*</code>, <code>/</code>, <code>ceil</code>, <code>round</code>:
+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.
-*{{xpsoc|#expr: -1*0}}
-*{{xpsoc|#expr: (-1e-200)*1e-200}}
-*{{xpsoc|#expr: -1/1e333}}
-*{{xpsoc|#expr: 0/-1}}
-*{{xpsoc|#expr: (-1e-200)/1e200}}
-*{{xpsoc|#expr: (1e-200)/-1e200}}
-*{{xpsoc|#expr: ceil(-.1)}}
-*{{xpsoc|#expr: -.2round0}}
-Passing <code>-0</code> on with unary <code>+</code>, binary <code>+</code>  and <code>-</code>, <code>*</code> (and hence operator <code>e</code>), <code>/</code>, <code>floor</code>, <code>ceil</code>:
+Applying #expr directly on a linked expression gives {{#expr:{{roote|.0000000000001}}}}, but it can also be used in a further computation, unlike the value just mentioned.
-*{{xpsoc|#expr: +(-1*0)}}
-*{{xpsoc|#expr: (-1*0)+(-1*0)}}
-*{{xpsoc|#expr: (-1*0)-0}}
-*{{xpsoc|#expr: 1*(-1*0)}}
-**{{xpsoc|#expr: (-1*0)e0}}
-*{{xpsoc|#expr: (-1*0)/1}}
-*{{xpsoc|#expr: floor(-1*0)}}
-*{{xpsoc|#expr: ceil(-1*0)}}
-However:
+. Writing numbers splitting off factors which are powers of 10 but written plainly.
-*{{xpsoc|#expr: -0}}
-*{{xpsoc|#expr: -10^-401}}
-Since 2011 the function #ifexpr takes both 0 and the float -0 as false:
+Example:
+*{{xpd1|gives=giving|rooteval|.0000000000001}}
-*{{xpsoc|#ifexpr:0|1|0}}
+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}},
-*{{xpsoc|#ifexpr:-1*0|1|0}}
+giving {{fineval|.0000000000001}}, but the result can also be used in a further computation.
-Also, as argument of a logical operator -0 is taken as false:
+Compare:
-*{{xpsoc|#expr:not(-1*0)}}
+*{{xpd0|#expr:(.0000000000001)^(1/2)}}
-*{{xpsoc|#expr:(-1*0)and1}}
-*{{xpsoc|#expr:(-1*0)or0}}
-If an expression of type float can have the value -0, then an operation that removes the minus sign from a possible -0, but does not affect any other result, is the addition of 0. If an expression may be of type integer then one can add trunc0.
+This uses the same method, but with intermediate application of #expr, giving an error  because of internediate results in scientific notation.
-*{{xpsoc|#expr:0+(-1*0)}}
-==Type conversion==
+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'' ):
-A float can be converted to type integer by operator trunc (note however that for 2^63 <= x <= 2^64 we get x - 2^64, for larger x we get 0; for x < -2^63 we get -2^63).
+*{{xpd0|#expr: ( -0.2 round 0 )}}
+*{{xpd0|#expr: 1*(-0.2 round 0)}}
+*{{xpd0|#expr: 0+(-0.2 round 0)}}
-An expression of type integer can be converted to float by adding 0. Note that for integers greater than 2^53 this involves rounding.
+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}}.
-==Limitations and workarounds==
+==Accuracy==
-The operator trunc gives the correct mathematical result of rounding toward 0 to an integer for integer-type numbers and for floats x inside the integer range: -2^63 <= x < 2^63. To also get the correct mathematical result for floats outside this range is simple, because these floats all have an integer value, so they can be left unchanged. [[Template:Trunc]] does this.
+:''The accuracy and format of numeric results varies with the operating system of the server.''
-The operator mod gives strange errors for some fairly large values of the second argument:
+Accuracy of the result of #expr is less than internally used within the computation of an expression:
-*{{xpsoc|#expr:123mod(2^32-1)}}
-[[Template:Modint]] works correctly for a larger range.
-The operator ''round'' with second argument 0 gives wrong results for odd numbers between 2^52 and 2^53, even though the exact results are representable as float. Also, the operator rounds integer-type numbers with an absolute value between 2^53 and 2^63 to float. [[Template:Round0]] always gives the expression for the exact result, for subsequent use in an expression, or for display (with the accuracy of this depending on the accuracy of the display function or template only).
+*{{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 operator ''floor'' rounds integer-type numbers with an absolute value between 2^53 and 2^63 to float, and not necessarily downward. Similarly the operator ''ceil'' rounds these numbers not necessarily upward. [[Template:Floor]] and [[Template:Ceil]] always give the expressions for the exact results, for subsequent use in an expression, or for display (with the accuracy of this, and the direction of rounding, depending on the display function or template only).
+;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-<font color="red">'''16'''</font> (see above):
+;<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''':
+;{{xpdoc|#expr:1+0.000000000004999889392}}
+;{{xpdoc|#expr:1+0.000000000004999889391}} below about 1 + 5E-<font color="red">'''12'''</font>.
 ==Branching depending on an expression==
-The function [[mw:Help:Extension:ParserFunctions##ifexpr|#ifexpr:]] produces one of two specified results, depending on the value of a boolean expression involving numbers and booleans (not strings). Examples:
+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}}.
-* {{xpsoc|1=#expr:2^10=1024}}
-Note that rounding errors can affect a comparison, even if they are not visible in the displayed values: the  internal values are compared. This applies even to large integers:
+;<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}}.
-*{{xpsoc|#expr:1024e20-1e23}}
-*{{xpsoc|1=#expr:1024e20-1e23=2.4e21}}
-Instead one may want to allow a relatively small difference that could be present due to rounding errors:
-*{{xpsoc|1=#expr:abs(1024e20-1e23-2.4e21)<1e8}}
-Again, for comparing a number of type float with one of type integer, the integer is converted to float. In this case the type is determined by the format of the number, e.g. 2 is an integer, but 2.0 and 2e0 are floats; also 12345678901234567890 is a float, because it is too large for an integer.
+{{xpd2|1=#ifexpr:2^10=1024|2=1|3=0}}
-Again, equality is not transitive with mixed types:
+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}}
-*{{xpsoc|#ifeq:12345678901234567|12345678901234568.0|1|0}}
+Similarly:
-*{{xpsoc|#ifeq:12345678901234568.0|12345678901234568|1|0}}
+*{{xpd0|1=#expr:sin pi=0}}
-*{{xpsoc|#ifeq:12345678901234567|12345678901234568|1|0}}
+*{{xpd0|#expr:abs sin pi<1e-15}}
-*{{xpsoc|#ifeq:12345678901234567|12345678901234567e0|1|0}}
+==Comparisons==
-*{{xpsoc|#ifeq:12345678901234567e0|12345678901234568|1|0}}
+#The function [[m:ParserFunctions#.23ifeq:|#ifeq:]] compares numbers and strings for equality (equal if both represent the same number or both are equal strings).
-*{{xpsoc|#ifeq:12345678901234567|12345678901234568|1|0}}
+#The function [[m:ParserFunctions#.23switch:|#switch:]] compares one string with multiple others, and correspondingly produces one of multiple specified results.
-*{{xpsoc|num|trunc(2^62)-trunc1+trunc(2^62)}}
+*{{xpdopepepec|#switch:FR|UK|London|FR|Paris|NL|Amsterdam}}
-*{{xpsoc|#ifeq:9223372036854775700|9223372036854775900|1|0}}
+<!--
-*{{xpsoc|#ifeq:9223372036854775900|9223372036854775800|1|0}}
+*{{xpd|#switch:UK|UK|3=GB=London|4=FR=Paris}}
-*{{xpsoc|#ifeq:9223372036854775700|9223372036854775800|1|0}}
+*{{xpd|#switch:ZZ|2=UK=London|3=FR=Paris|4=no match}}
+-->
-==Comparisons==
+*{{xpd3|#ifeq:3|3.0|1|0}}
-The functions <code>[[Template:If##ifeq|#ifeq]]</code> and <code>[[mw:Help:Extension:ParserFunctions##switch|#switch]]</code> compare numbers and strings for equality using PHP operator [http://www.php.net/manual/en/language.operators.comparison.php ==], the same as the equality operator mentioned above, but now applied directly to the expanded wikitext of the arguments. For comparison as numbers no expressions (not even constants) are allowed, but in this case the unary plus and minus and the e of scientific notation are taken as part of the number, instead of as operators. Without e and decimal point the type is integer, otherwise it is float. As mentioned above, when an integer is compared with a float, the integer is converted to float first.
+*{{xpd3|#ifeq:3|03|1|0}}
+*{{xpd3|#ifeq:0.00003456|3.456E-05|1|0}}
+:*Note that '''#ifeq:''' unlike '''#expr:''' accepts exponential notation on input.
+:::* <nowiki>{{#ifexpr:0.00003456 = 3.456E-05|1|0}}</nowiki> gives "{{#ifexpr:0.00003456 = 3.456E-05|1|0}}"
+*{{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}}
-* {{xpsoc|#ifeq:3|3.0|1|0}}
+[[ParserFunctions#.23ifeq:|#ifeq:]] allows to compare strings containing equal signs:
-* {{xpsoc|#ifeq:3|03|1|0}}
+{|
-* {{xpsoc|#ifeq:0.00003456|3.456E-05|1|0}}
+!#switch form
-* {{xpsoc|#ifeq:1e23|.1e24|1|0}} although rounding both numbers to float gives different internal numbers:
+!#ifeq form
-** {{xpsoc|#expr:1e23-.1e24}}
+|-
-** {{xpsoc|1=#expr:1e23=.1e24}}
+|{{xpd|#switch:-1.0|2=-1=okay|3=fail|s=</td><td>}}
-** {{xpsoc|1=#ifexpr:1e23=.1e24|2=1|3=0}}
+|{{xpd|#ifeq:-1.0|-1|okay|fail|s=</td><td>}}
-* {{xpsoc|#ifeq:9034567890123456789|9034567890123456788|1|0}} (two numbers of type integer, therefore only true if exactly equal); compare:
+|-
-* {{xpsoc|#ifeq:9034567890123456700.0|9034567890123456800|1|0}} (due to the decimal point in one number, both are rounded to float before the comparison, so the comparison is cruder)
+|<code>"<nowiki>{{#switch: {{#expr:-1.0}} |-1=okay|fail}}</nowiki>"</code> gives "{{#switch: {{#expr:-1.0}} |-1=okay|fail}}" &nbsp;
+|-
+|{{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==
-Long expressions are allowed, see [[Template:Long expression demo]]. However, see also [[Help:Expansion#Efficiency|efficiency]].
+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.)
-==Error messages==
+Do not use
-Examples for all known [[mw:Help:Extension:ParserFunctions##expr|#expr:]] and [[mw:Help:Extension:ParserFunctions##ifexpr|#ifexpr:]] error messages. The error texts are within the tags &lt;strong class="error">..&lt;/strong>.
+*<nowiki>{{#ifexpr:x>0|x|-x}}</nowiki>
+for long expressions as it triples the length.
-*{{xpdoc|#expr:1/0}}
+Similarly do not use mod to round or conversely, because it doubles the length of the expression.
-*{{xpdoc|#expr:2*}}
-*{{xpdoc|#expr:1 2}}
-*{{xpdoc|#ifexpr:1*/2}}
-*{{xpdoc|#expr: 1 (2)}}
-*{{xpdoc|#expr: (1}}
-*{{xpdoc|#expr: 1)}}
-*{{xpdoc|#expr:2*123,456}}
-*{{xpdoc|#expr:{{{a}}}}}
-*{{xpdoc|#ifexpr:3%2}}
-*{{xpdoc|#ifexpr:abc}}
-*{{xpdoc|#expr:abc.def}}
-{&#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}}}}
+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>
-{&#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}}}}
+This "exponential" growth of expressions, with much repetition, is due to the lack of variables (in the computer programming sense); however, see also [[VariablesExtension]].
-{&#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")
+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)
-INF also appears when an intermediate result is of range:
+For the [[Wikipedia:Template limits|pre-expand include size maximum]] the first method does not help, but the second does.
-*{{xpsoc|#expr:1e309/1e308}}
-*{{xpsoc|#expr:1e200*1e200*1e-300}}.
-but
-*{{xpsoc|#expr:1e200*(1e200*1e-300)}}.
-{&#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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))}}}}
+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.
-{&#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))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))}}}}
+==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>. Note that with the old preprocessor the "=" in "class=error" disturbs the numbering of unnamed parameters, if one of them produces an error message: <nowiki>{{t1|{{#expr:1/0}}}}</nowiki> gives {{t1|{{#expr:1/0}}}}.
-{{xpd0|#expr:3.4.5.6}} &#160; <small>(no feature, only an oddity)</small>
+{| cellspacing="0" cellpadding="0"
+|-
+||'''Expression'''
+||'''Error message'''
+|-
+||{{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}}}} ( "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).
+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 unintended:
+Wikitext without error message from the parser functions, but typically an error while using or attempting to use them:
 {| cellspacing="0" cellpadding="0"
@@ Line 743: / Line 697: @@
 |-
 |valign="top"|<nowiki>{{#expr:2*3}</nowiki>
-|valign="top"| <nowiki>{{#expr:2*3}</nowiki>
+|valign="top"| {{#expr:2*3}
 |(too few braces, the whole is interpreted as plain text)
 |}
-==Checking for a number==
+;A crude but informative "unrecognised word" error message can be generated intentionally. Only the first identified error is shown:
-Check whether a string is a valid numeric expression:
+:{&#123;<tt> #expr: 2*</tt>{&#123;<tt> #ifexpr: 3*4>10|toolarge|3*4 </tt>&#125;} &#125;} gives
-*<code><nowiki>{{#if:{{#ifexpr:3}}|0|1}}</nowiki></code> gives {{#if:{{#ifexpr:3}}|0|1}}
+::{{#expr:2*{{#ifexpr:3*4>10|toolarge|3*4}}}},
-*<code><nowiki>{{#if:{{#ifexpr:3-2}}|0|1}}</nowiki></code> gives {{#if:{{#ifexpr:3-2}}|0|1}}
+:{&#123;<tt> #expr: 2*</tt>{&#123;<tt> #ifexpr: 3*4>10|too large|3*4 </tt>&#125;} &#125;} gives
-*<code><nowiki>{{#if:{{#ifexpr:3 2}}|0|1}}</nowiki></code> gives {{#if:{{#ifexpr:3 2}}|0|1}}
+::{{#expr:2*{{#ifexpr:3*4>10|too large|3*4}}}}.
-Find the value represented by a string if it is a valid numeric expression, otherwise just return the string:
+See also [[Help:ParserFunctions#.23iferror:|#iferror]].
-*<code><nowiki>{{#iferror:{{#expr:3}}|3}}</nowiki></code> gives {{#iferror:{{#expr:3}}|3}}
-*<code><nowiki>{{#iferror:{{#expr:3-2}}|3-2}}</nowiki></code> gives {{#iferror:{{#expr:3-2}}|3-2}}
-*<code><nowiki>{{#iferror:{{#expr:3 2}}|3 2}}</nowiki></code> gives {{#iferror:{{#expr:3 2}}|3 2}}
-Check whether a string is a number:
-*<code><nowiki>{{#ifeq:3|{{#expr:3}}|1|0}}</nowiki></code> gives {{#ifeq:3|{{#expr:3}}|1|0}}
-*<code><nowiki>{{#ifeq:03|{{#expr:03}}|1|0}}</nowiki></code> gives {{#ifeq:03|{{#expr:03}}|1|0}}
-*<code><nowiki>{{#ifeq:3-2|{{#expr:3-2}}|1|0}}</nowiki></code> gives {{#ifeq:3-2|{{#expr:3-2}}|1|0}}
-*<code><nowiki>{{#ifeq:3 2|{{#expr:3 2}}|1|0}}</nowiki></code> gives {{#ifeq:3 2|{{#expr:3 2}}|1|0}}
 ==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.
+Only the ASCII [[hyphen]] ([[hyphen-minus]]) and [[minus sign]]s work as minus signs; dashes are not permitted.  The output, however, will always be in the form of a hyphen-minus:
-* 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)
+{| class="wikitable"
-* Only a handful of character references by name are substituted early by MediaWiki, all others are interpreted only by the browser.
+|hyphen-minus||{{xpd0|#expr:-12|gives={{!}}{{!}}}}
-* 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)
+|Unicode hyphen (U+2010, ‐) || <code>"{&#123;#expr:‐12}&#125;"</code> || "{{#expr:‐12}}"
-| {{xpd0|#expr:-12|gives={{!!}}}}
 |-
-| hyphen-minus, typed as the numerical character reference <tt>&amp;#x2D;</tt>
+|[[Minus_sign#Character_codes|minus sign]] produced by &amp;minus;||<code>"{&#123;#expr:−12}&#125;"</code> || "{{#expr:−12}}"
-| <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>
+|&amp;minus;||<code>"{&#123;<nowiki/>#expr:&amp;minus;12}&#125;"</code> || "{{#expr:&minus;12}}"
-| <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)
+|[[Dash#Em_dash|em dash]] produced by &amp;mdash;||<code>"{&#123;<nowiki/>#expr:—12}&#125;"</code> || "{{#expr:—12}}"
-| {{xpd0|#expr:−12|gives={{!!}}}}
 |-
-| minus sign, typed as the numerical character reference <tt>&amp;#x2212;</tt>
+|&amp;mdash;||<code>"{&#123;<nowiki/>#expr:&amp;mdash;12}&#125;"</code> || "{{#expr:&mdash;12}}"
-| <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>
+|[[Dash#En_dash|en dash]] produced by &amp;ndash;||<code>"{&#123;#expr:–12}&#125;"</code> || "{{#expr:–12}}"
-| <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>
+|&amp;ndash;||<code>"{&#123;<nowiki/>#expr:&amp;ndash;12}&#125;"</code> || "{{#expr:&ndash;12}}"
-| <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}}]
 |}
@@ Line 841: / Line 732: @@
 ==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:
+Guidelines such as [[WP: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
@@ Line 863: / Line 754: @@
 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.
-If you want to calculate with [[mw:Help:Magic words|Magic words]] and return group seperated results you can use formatnum:<br>
+==Tactics for handling extreme numbers==
-<code><nowiki>{{formatnum: {{#expr: {{NUMBEROFPAGES:R}} - {{NUMBEROFFILES:R}} }} }}</nowiki></code> = {{formatnum: {{#expr: {{NUMBEROFPAGES:R}} - {{NUMBEROFFILES:R}} }} }} (instead of {{#expr: {{NUMBEROFPAGES:R}} - {{NUMBEROFFILES:R}} }}).
+In the digital storage of numbers, the effects of [[truncation error]] on numeric precision might cause some extreme decimal numbers (above 1E13 or below 1E-12), or other E-notation numbers, to mismatch during comparisons. There are some tactics which can help, such as comparing results with "<code>#ifeq</code>" rather than "<code>#ifexpr</code>".
+; Comparing large numbers
+The floor function might mismatch the original value of a large number, by a tiny amount, and so comparisons can be made with <code>#ifeq</code> between separate expressions. For example:
-== See also ==
+::* <code><nowiki>{{#ifexpr: floor( 1.36E4 ) = 1.36E4|Equal|Differ}}</nowiki></code> gives "{{#ifexpr: floor( 1.36E4 ) = 1.36E4|Equal|Differ}}"
-*[[Help:Mod, round, floor, ceil, trunc]]
+::* <code><nowiki>{{#ifexpr: floor( 1.33E4 ) = 1.33E4|Equal|Differ}}</nowiki></code> gives "{{#ifexpr: floor( 1.33E4 ) = 1.33E4|Equal|Differ}}"
-*[[Help:Calculation accuracy]]
+::* <code><nowiki>{{#ifexpr: floor( 1.52E4 ) = 1.52E4|Equal|Differ}}</nowiki></code> gives "{{#ifexpr: floor( 1.52E4 ) = 1.52E4|Equal|Differ}}"
-*[[Help:Comparison between ParserFunctions syntax and TeX syntax]]
+::* <code><nowiki>{{#ifexpr: floor( 1.36E13 ) = 1.36E13|Equal|Differ}}</nowiki></code> gives "{{#ifexpr: floor( 1.36E13 ) = 1.36E13|Equal|Differ}}"
-*[[:Category:Mathematical templates]]
+::* <code><nowiki>{{#ifexpr: trunc( 1.36E13 ) = 1.36E13|Equal|Differ}}</nowiki></code> gives "{{#ifexpr: trunc( 1.36E13 ) = 1.36E13|Equal|Differ}}"
-*[[mw:Extension:MathStatFunctions]]
-*[[mw:Extension:Foxway]]
-*http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions/ParserFunctions/Expr.php
-{{refs}}
+However, using  <code>#ifeq</code> to compare the results of 2 expressions can work:
+::* <code><nowiki>{{#ifeq: {{#expr:floor(1.33E4) }} | {{#expr:1.33E4}}|Equal|Differ}}</nowiki></code> gives "{{#ifeq: {{#expr:floor(1.33E4) }} | {{#expr:1.33E4}}|Equal|Differ}}"
+::* <code><nowiki>{{#ifeq: {{#expr:floor(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}}</nowiki></code> gives "{{#ifeq: {{#expr:floor(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}}"
+::* <code><nowiki>{{#ifeq: {{#expr:trunc(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}}</nowiki></code> gives "{{#ifeq: {{#expr:trunc(1.36E13) }} | {{#expr:1.36E13}}|Equal|Differ}}"
+The truncation-error amount can usually be displayed by subtraction:
+::* <code><nowiki>{{#expr: floor(1.36E4) - 1.36E4 }}</nowiki></code> gives "{{#expr: floor(1.36E4) - 1.36E4 }}"
+::* <code><nowiki>{{#expr: floor(13600) - 13600 }}</nowiki></code> &nbsp; gives "{{#expr: floor(13600) - 13600 }}"
+::* <code><nowiki>{{#expr: floor(1.36E13) - 1.36E13 }}</nowiki></code> gives "{{#expr: floor(1.36E13) - 1.36E13 }}"
+::* <code><nowiki>{{#expr: trunc(1.36E13) - 1.36E13 }}</nowiki></code> gives "{{#expr: trunc(1.36E13) - 1.36E13 }}"
-{{h:f|enname=Calculation}}
+There are similar workarounds to bypass other limitations due to [[truncation error]] in the handling of extreme numbers.
-[[Category:Editor handbook]]
+==See also==
+*[[mw:Help:Extension:ParserFunctions]]
+**[http://bugzilla.wikimedia.org/attachment.cgi?id=2751 ParserFunctions patch] ([[bugzilla:6068]])
+*[[Help:Parser function]] (general considerations)
+*[[Help:Substitution]]
+*[[m:Category:Mathematical templates]]
+{{mediawiki}}
+{{Help navigation}}
+[[Category:Wikipedia text help]]
+[[Category:Wikipedia features]]