Manuals/calci/XMY

XMY(x,y)

• where $x$ and $y$ are integer values.

Description

• XMY() subtracts the second argument value from the first one and displays the result of subtraction.
• Minus means "take away" or "Decrease by". Here, the second parameter is subtracted from first parameter.
• Arguments $x,y$ can be positive or negative.
• For more than two arguments, only first two values are considered for subtraction. 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

1. =XMY(300,45) = 255
2. =XMY(-456,-34) = -422
3. =XMY(26,20,4) = 6
4. =XMY(TRUE, 0.6) = 0.4

Related Videos

SUBTRACT

See also

• XPY
• XSY
• XDY

References

• Minus

• List of Main Z Functions

• Z3 home