Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Get nth match with INDEX / MATCH in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get first column number in range in Excel
  • Left Lookup in Excel
  • How to retrieve first match between two ranges in Excel

Data Analysis Examples

  • Everything about Charts in Excel
  • Working With Tables in Excel
  • Excel Pie Chart
  • How to create Checklist in Excel
  • How to count table rows in Excel

Data Validation Examples

  • Excel Data validation must begin with
  • Excel Data validation no punctuation
  • Excel Data validation allow weekday only
  • Excel Data validation specific characters only
  • Excel Data validation exists in list

Tag: GAMMALN function

GAMMALN function: Description, Usage, Syntax, Examples and Explanation

by

What is GAMMALN function in Excel? GAMMALN function is one of Statistical functions in Microsoft Excel that returns the natural logarithm of the gamma function, Γ(x). Syntax of GAMMALN function GAMMALN(x) The GAMMALN function syntax has the following arguments: X    Required. The value for which you want to calculate GAMMALN. GAMMALN formula explanation If x is nonnumeric, …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to split text string at specific character in Excel
  • SUBSTITUTE function: Description, Usage, Syntax, Examples and Explanation
  • How to count number of characters of text in a cell in Excel
  • How to check if cell contains all of many things in Excel
  • LOWER function: Description, Usage, Syntax, Examples and Explanation
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • Count times in a specific range in Excel
  • How to calculate next scheduled event in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Generate series of dates by weekends in Excel
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan principal payments in Excel
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • How to Calculate Tax Rates in Excel
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles