• Home
  • VBA Tutorial
  • VBA Cheat Sheet
  • Excel SQL Add-In
  • VBA Time Saver
  • VBA Web Scraping Kit
  • Excel LOOKUP Wizard
  • Merch

Analyst Cave

Simply the best place to learn Excel and Analytics

  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video
  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video

Home ยป Excel Functions Reference

Excel Functions Reference

Financial Functions
Math & Trigonometric Functions

Download VBA Time Saver

VBA Time Saver Kit

Ready VBA Code snippets for Arrays, Strings, File Dialogs, Read/Write Files, Timers, Progress Bar

Download LOOKUP Wizard

Excel Lookup Wizard Book1

Lookup data from external Excel files and worksheets with the Excel LOOKUP Wizard AddIn!

Articles