Skip to content
SOPHUC

Excel is easy to learn

Menu
  • Home
  • Tips
  • Excel functions
  • text strings
  • Date function
  • Database functions

Category: Information function

How to use TYPE Function in Excel
Information function

How to use TYPE Function in Excel

ExcelJuly 17, 2020July 18, 20200
For a supplied value, the Excel TYPE function returns an integer that represents the value’s data type. Syntax:= TYPE (value) …
Read More
How to use SHEETS Function in Excel
Information function

How to use SHEETS Function in Excel

ExcelJuly 16, 2020May 29, 20200
The Excel SHEETS function returns the total number of sheets in a given reference.  When no arguments are supplied SHEETS …
Read More
How to use SHEET Function in Excel
Information function

How to use SHEET Function in Excel

ExcelJuly 15, 2020May 29, 20200
The Excel SHEET function returns the index number of a sheet in Excel. It will report the sheet number for …
Read More
How to use NA Function in Excel
Information function

How to use NA Function in Excel

ExcelJuly 13, 2020May 29, 20200
The Excel NA function returns the #N/A error. #N/A means “not available” or “no value available”. You can nest the …
Read More
How to use N Function in Excel
Information function

How to use N Function in Excel

ExcelJuly 12, 2020July 12, 20200
The Excel N function returns a number when given a value. The N function can be used to convert TRUE …
Read More
How to use ISTEXT Function in Excel
Information function

How to use ISTEXT Function in Excel

ExcelJuly 11, 2020May 29, 20200
The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not. You can use the …
Read More
How to use ISREF Function in Excel
Information function

How to use ISREF Function in Excel

ExcelJuly 10, 2020May 28, 20200
The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not. You can use the ISREF …
Read More
How to use ISODD Function in Excel
Information function

How to use ISODD Function in Excel

ExcelJuly 8, 2020May 28, 20200
The Excel ISODD function returns TRUE when a numeric value is odd, and FALSE for even numbers. ISODD will return …
Read More
How to use ISNUMBER Function in Excel
Information function

How to use ISNUMBER Function in Excel

ExcelJuly 6, 2020May 28, 20200
ISNUMBER in excel is a logical function in excel which we use to find out that if the target or …
Read More
How to use ISNONTEXT Function in Excel
Information function

How to use ISNONTEXT Function in Excel

ExcelJuly 5, 2020May 28, 20200
The Excel ISNONTEXT function returns TRUE for any non-text value, for example, a number, a date, a time, etc. The …
Read More

Posts navigation

1 2 3 Next ›
Search for

Popular Posts

    Recent Posts

    • How to use VAR.S Function in Excel
    • 10 Ways to Raise Your Excel PivotTable Game
    • What are PivotTables in Excel? What Can You Do with Them?
    • 4 Reasons for Marketers to Love Pivot Tables [Excel Tricks]
    • SUBTOTAL in Excel: Everything You Should Know

    Recent Comments

      Categories

      • Average
      • Compatibility functions
      • Count
      • Cube funcitons
      • Database functions
      • Date function
      • Engineering functions
      • Excel
      • Excel functions
      • excel min max
      • Financial functions
      • Information function
      • Logic function
      • Lookup and reference
      • Math and trigonometry
      • Power BI
      • Statistical functions
      • sum
      • text strings
      • Tips
      • Vlookup excel

      Sitemap

      1. Post
      2. Page
      3. category
      4. Post_tag
      5. Author
      Proudly powered by WordPress
      RedWaves theme by Themient
      Menu
      Search for
      • Home
      • Tips
      • Excel functions
      • text strings
      • Date function
      • Database functions