Tips and Tricks of MS PowerPoint
December 3, 2021
Stacking in EXCEL
December 16, 2021
returns the random integer between two numbers. Two arguments are used: the lower end of the range and the upper end of the range.
Syntax:RANDBETWEEN(bottom, top)
2. Convert to Roman numerals
Insert a number, and the “ROMAN” function transforms it into the corresponding Roman numeral.
Syntax: ROMAN(number to convert, optional style)
3. Determine the part of a year with YEARFRAC
“YEARFRAC” returns a percentage of a year. The value returned from the function is a percentage less than 1, implying that the span of dates is less than a full year. The exact one-year period returns 1, and a period longer than one year returns a number greater than 1. Syntax: YEARFRAC(start_date, end_date, [basis])
4. Find the data type
Excel “TYPE” function returns the type of a value. It is categorized as an information function, for instance, cell A4 has 16 and A5 has “Mango”.
Syntax: TYPE(value)
The “TYPE” function returns five possible values: 1= number; 2= text; 4= a logical value (And, Or, and so on); 16= an error; 64= an array.
5. CONVERT()
The “CONVERT()” is a flexible formula that can be used to convert currencies, temperatures and much more.
Syntax: CONVERT(number, from_unit, to_unit)
Contributor : Team Leveraged Growth
