logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
Tips and Tricks of MS PowerPoint
December 3, 2021
Stacking in EXCEL
December 16, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW

December 9, 2021
1. Generate a range of random numbers “RANDBETWEEN”

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)

s1
s2

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)

s3
s4

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])

s5
s6

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)

s7

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)

11
22

Contributor : Team Leveraged Growth

Share
0

Related posts

December 16, 2021

Stacking in EXCEL


Read more
November 25, 2021

Circular Referencing Solution


Read more
November 18, 2021

Printing tricks


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'