Difference between revisions of "Manuals/calci/NUMSCORE"
Jump to navigation
Jump to search
| (One intermediate revision by one other user not shown) | |||
| Line 8: | Line 8: | ||
*<math>Start</math> is the minimum number to start the sequence. | *<math>Start</math> is the minimum number to start the sequence. | ||
*Numbers are arithmetical value which are containing positive numbers,negative numbers and including zero. | *Numbers are arithmetical value which are containing positive numbers,negative numbers and including zero. | ||
| − | *So this function including the minimum number but not including the maximum number. | + | *So this function is including the minimum number, but not including the maximum number. |
| − | *Also | + | *Also, when limit and start both are in Integers, function will return the result in Integers. |
| − | *Suppose start number is in decimal then | + | *Suppose start number is in decimal, then the function will return the result in decimal, increasing with 1. |
==Examples== | ==Examples== | ||
| Line 16: | Line 16: | ||
#NUMSCORE(32,22.3) = 22.3 23.3 24.3 25.3 26.3 27.3 28.3 29.3 30.3 31.3 | #NUMSCORE(32,22.3) = 22.3 23.3 24.3 25.3 26.3 27.3 28.3 29.3 30.3 31.3 | ||
#NUMSCORE(4,-11) = -11 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 0 1 2 3 | #NUMSCORE(4,-11) = -11 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 0 1 2 3 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=vNVAC09waII|280|center|Numbers}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 06:49, 13 February 2019
NUMSCORE (Limit,Start)
- and are any real numbers.
and 
are any real numbers.Description
- This function shows numbers increasing by 1 with in the given limit.
- In , is the maximum number which is not included in the list.
- is the minimum number to start the sequence.
- Numbers are arithmetical value which are containing positive numbers,negative numbers and including zero.
- So this function is including the minimum number, but not including the maximum number.
- Also, when limit and start both are in Integers, function will return the result in Integers.
- Suppose start number is in decimal, then the function will return the result in decimal, increasing with 1.
,Examples
- NUMSCORE(19,10) = 10 11 12 13 14 15 16 17 18
- NUMSCORE(32,22.3) = 22.3 23.3 24.3 25.3 26.3 27.3 28.3 29.3 30.3 31.3
- NUMSCORE(4,-11) = -11 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 0 1 2 3