Manuals/calci/GENERATENUMBER

Revision as of 14:53, 2 May 2019 by Devika (talk | contribs) (→‎Related Videos)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
GENERATENUMBER (Type,Range,HowMany)


  • is the type of numbers.
  • is the range between which numbers are displayed.
  • is the count as how many numbers are to be displayed.

Description

  • This function generates different type of numbers.
  • In  ,  are types of the numbers.
  •   is the maximum limit of the displaying numbers.
  •   is the count as how many numbers are to be displayed.
  • Here the types of numbers can be
1.Positive (Decimals)
2.Negative (Decimals) 
3.Positive:Integer 
4.Negative:Integer 
5.Zero 
6.Integer.
  • So we can generates the different types of numbers with in the given limit of the numbers.
  • For example GENERATENUMBER("negative",10,4),here this function will generates four negative decimal numbers with in the limit 10.

Examples

  1. GENERATENUMBER("positive",56,3) = 38.66618481936558 55.020642277354 32.14405834876233
  2. GENERATENUMBER("negative",765,4) = -125.1246516313229 -245.53719329413008 -307.9884140765779 -571.3801665900556
  3. GENERATENUMBER("negative:integer",6543,7) = -2738 -2254 -1066 -5112 -328 -74 -4253
  4. GENERATENUMBER("integer",63,10.3) = -52 -18 38 23 24 9 24 -22 1 60 -49
  5. GENERATENUMBER("zero",5,2) = 0 0

Related Videos

Integers

See Also

References