Difference between revisions of "Manuals/calci/REMAINDER"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''REMAINDER(number,divisor) '''</div><br/> *<math>number</math> is a single number or set of numbers, and *<math>divisor</math> is any real number...")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''REMAINDER(number,divisor) '''</div><br/>
+
<div style="font-size:30px">'''REMAINDER(Number,Divisor) '''</div><br/>
*<math>number</math> is a single number or set of numbers, and
+
OR
*<math>divisor</math> is any real number.
+
<div style="font-size:30px">'''MOD (Number,Divisor) '''</div><br/>
 +
*<math>Number</math> is a single number or set of numbers, and
 +
*<math>Divisor</math> is any real number.
 +
**REMAINDER(),returns the remainder from division.
  
 
==Description==
 
==Description==
Line 11: Line 14:
  
 
==ZOS==
 
==ZOS==
*The syntax is to calculate remainder of the given numbers in ZOS is <math>REMAINDER(number,divisor)</math>.
+
*The syntax is to calculate remainder of the given numbers in ZOS is <math>REMAINDER(Number,Divisor)</math>.
**<math>number</math> and <math>divisor</math> are any real numbers.
+
**<math>Number</math> and <math>Divisor</math> are any real numbers.
 
*For e.g.,REMAINDER(10,2),REMAINDER(50.2,-4)
 
*For e.g.,REMAINDER(10,2),REMAINDER(50.2,-4)
  
Line 23: Line 26:
 
#=REMAINDER(-52,7)=4
 
#=REMAINDER(-52,7)=4
 
#=REMAINDER(0,9)=0
 
#=REMAINDER(0,9)=0
#=REMAINDER(9,0)=NAN
+
#=REMAINDER(9,0)=#N/A (DIVISOR == 0)
 
#=REMAINDER(5.5,2)=1.5
 
#=REMAINDER(5.5,2)=1.5
  

Latest revision as of 10:33, 9 June 2020

REMAINDER(Number,Divisor)


OR

MOD (Number,Divisor)


  • is a single number or set of numbers, and
  • is any real number.
    • REMAINDER(),returns the remainder from division.

Description

  • This function gives the remainder of the number after dividing with given number. This is similar to function
  • When we divide two integers we will get the result like this: with remainder . Here is the dividend, is the divisor, is the Quotient and is the remainder.So .
  • This function will return the result as error when the value is 0.
  • Suppose the value of and with same sign either '+' or '-',then the result is also displayed with the same sign.
  • But if and are with different signs,one positive and other negative, then the result will have sign only.

ZOS

  • The syntax is to calculate remainder of the given numbers in ZOS is .
    • and are any real numbers.
  • For e.g.,REMAINDER(10,2),REMAINDER(50.2,-4)

Examples

  1. =REMAINDER(7,2)=1
  2. =REMAINDER(-11,-3)=-2
  3. =REMAINDER(75,5)=0
  4. =REMAINDER(12,-4)=0
  5. =REMAINDER(85,-9)=-5
  6. =REMAINDER(-52,7)=4
  7. =REMAINDER(0,9)=0
  8. =REMAINDER(9,0)=#N/A (DIVISOR == 0)
  9. =REMAINDER(5.5,2)=1.5

For an array of numbers/dividends, a table with remainder values is displayed as follows -

  • REMAINDER(11..15,4)
Number Divisor MOD
11 4 3
12 4 0
13 4 1
14 4 2
15 4 3


  • REMAINDER([66,34,21],8)
Number Divisor MOD
66 8 2
34 8 2
21 8 5

Related Videos

Remainder

See Also

References

Remainder