Manuals/calci/XPY
Jump to navigation
Jump to search
XPY(x,y)
- where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y} are integer values.
Description
- XPY() multiplies the two argument values and displays the product.
- Number arguments Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x,y} can be positive or negative.
- For more than two arguments, only first two values are multiplied. Rest values are ignored.
- If logical values, empty cells or text are entered directly as a part of argument, they are ignored.
- If arguments is an array or reference, numbers and logical values are considered. Empty cells and text are ignored.
- Logical values are evaluated as TRUE=1, FALSE=0.
Examples
- =XPY(4,5) = 20
- =XPY(-4,5) = -20
- =XPY(2,55,3) = 110
- =XPY(0.1,TRUE) = 0.1
Related Videos
See also
References