Manuals/calci/XPY

From ZCubes Wiki
Revision as of 03:57, 23 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''XPY(x,y)'''</div><br/> *where <math>x</math> and <math>y</math> are integer values. == Description == *XPY() multiplies the two argument va...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
XPY(x,y)


  • where and  are integer values.


Description

  • XPY() multiplies the two argument values and displays the product.
  • Number arguments 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

  1. =XPY(4,5) = 20
  2. =XPY(-4,5) = -20
  3. =XPY(2,55,3) = 110
  4. =XPY(0.1,TRUE) = 0.1

Related Videos

PRODUCT

See also

References