Manuals/calci/XMY

XMY(x,y)


  • where and  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   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

References