Difference between revisions of "Manuals/calci/REMAINDER"
(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( | + | <div style="font-size:30px">'''REMAINDER(Number,Divisor) '''</div><br/> |
− | *<math> | + | OR |
− | *<math> | + | <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( | + | *The syntax is to calculate remainder of the given numbers in ZOS is <math>REMAINDER(Number,Divisor)</math>. |
− | **<math> | + | **<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)= | + | #=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
- =REMAINDER(7,2)=1
- =REMAINDER(-11,-3)=-2
- =REMAINDER(75,5)=0
- =REMAINDER(12,-4)=0
- =REMAINDER(85,-9)=-5
- =REMAINDER(-52,7)=4
- =REMAINDER(0,9)=0
- =REMAINDER(9,0)=#N/A (DIVISOR == 0)
- =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
See Also
References