Formulas & functions
How a function works, with worked examples you can paste.
- SUBTOTAL Formula Shortcut: Insert It Quickly in ExcelIn Excel for Microsoft 365 on Windows, press Alt+= to run AutoSum, but this is not a dedicated SUBTOTAL shortcut. To guarantee…
- PostgreSQL Built-In Functions and How to Use ThemPostgreSQL built-in functions are ready-to-use operations for working with values and database information. They cover tasks such as changing text, calculating dates,…
- SQL String Functions: Syntax and Practical ExamplesSQL string functions let you inspect, combine, clean, and transform text values in a database. Common examples include LOWER, UPPER, TRIM, SUBSTRING,…
- Table Functions in Tableau: How They WorkIn Tableau, table functions are functions used in table calculations to compute results across the values currently displayed in a visualization. They…
- SQL SPLIT Function: Syntax, Examples, and AlternativesThere is no single, standard SQL SPLIT() function that works in every database. To split text into rows, use your database’s equivalent:…
- Power Query Splitter Functions and When to Use ThemPower Query splitter functions divide text at delimiters, specified characters, or other boundaries. For a simple exact separator, use Text.Split; for a…
- Subtotal Formula With SUMIF in Excel: What Works and WhyIn Excel, SUMIF adds values that meet a condition, while SUBTOTAL can recalculate over rows left visible by a filter; neither function…
- Arcade String Functions: What They Do and How to Use ThemIn Esri Arcade, string functions work with text: they can join values, search for characters, extract part of a string, change letter…
- Excel LEN Function: Count Text Length and SpacesIn Microsoft Excel, the LEN function gives the length of a text string by counting its characters. For example, if A2 contains…
- Excel SUBTOTAL Formula: How to Sum Filtered Data and MoreTo total a filtered list in Excel, place the result outside the list and use =SUBTOTAL(9,B2:B100), assuming the values you want to…
- How to Differentiate Log Functions Using the Chain RuleTo differentiate a logarithm of a function, use the chain rule: the derivative of ln(u) is u′/u. For a logarithm with base…
- Java String Functions: Methods, Examples, and Common UsesIn Java, “string functions” usually means methods of the String class, such as length(), substring(), contains(), and replace(). These methods inspect, search,…
- How to Calculate a Subtotal in Excel: Formula and ExamplesTo calculate a subtotal in Excel, add the amounts in the relevant range; with item amounts in B2:B6, enter =SUM(B2:B6) in the…
- SUBTOTAL Formula in Excel: How to Use It and Filter DataTo total a range in Excel while excluding rows hidden by a filter, use =SUBTOTAL(9,B2:B10). This example assumes the values to add…
- Log Functions in Excel: How to Calculate LogarithmsTo calculate a logarithm in Excel, use LOG: with the value in A2 and the base in B2, enter =LOG(A2,B2). For a…
- Python String Functions: Methods, Uses, and ExamplesPython string functions are built-in tools and string methods for creating, inspecting, searching, splitting, and formatting text. For example, len('Python') returns 6,…
- SQL Server String Functions and How to Use ThemSQL Server string functions are built-in T-SQL tools for combining, searching, measuring, extracting, and changing text. Functions such as CONCAT, SUBSTRING, CHARINDEX,…
- Excel Add Quotes Around Text With Formulas and TipsYes. In Excel for Microsoft 365 on Windows, enter =""""&A2&"""" in another cell to place straight double quotation marks around the text…
- Excel 2013 Array Formulas: How to Enter and Use ThemIn Excel 2013, an array formula performs calculations on one or more sets of values and may return a single result or…
- Excel 365 Table Formulas: Structured References ExplainedExcel 365 table formulas are formulas entered in an Excel table that can use readable column names, such as Sales[Amount], instead of…
- Weighted Average in Excel: Formula and ExampleIn Excel, calculate a weighted average by multiplying each value by its weight, adding those products, and dividing by the sum of…
- SUMPRODUCT in Excel: Examples, Criteria, and TipsA simple example of SUMPRODUCT in Excel is =SUMPRODUCT(B2:B5,C2:C5): if B2:B5 contains quantities and C2:C5 contains unit prices, the formula multiplies each…
- Excel ROUND Function: Examples, Rules, and Common ErrorsTo round a number in Excel, use ROUND: with 12.345 in cell A2, enter =ROUND(A2,2) in another cell to get 12.35. The…
- PMT in Excel: Example Formula and Payment GuideFor a $20,000 loan at 6% annual interest over 36 monthly payments, enter the principal in B1, annual rate in B2, and…
- CLEAN Function in Excel: Examples and Common FixesIf the text you want to clean is in A2, enter =CLEAN(A2) in another cell. For example, if A2 contains North, a…
- PMT Function in Excel: Example and Payment FormulaWith the loan amount in B2, annual interest rate in B3, and term in years in B4, enter =PMT(B3/12,B4*12,B2) to calculate a…
- Exact Match Lookup in Excel: Formulas and TipsFor Microsoft 365, use XLOOKUP with exact-match mode to find a key: if the lookup value is in E2, keys are in…
- Weighted Average in Excel: Formula and ExamplesTo calculate a weighted average in Excel, multiply each value by its weight, add those products, then divide by the sum of…
- Entering an Array Formula in Excel: Steps and ExamplesIn Microsoft Excel for Microsoft 365 on Windows, enter a dynamic array formula in one cell and press Enter; Excel will spill…
- Energy Audit in Excel: Steps, Formulas, and LimitsYes—you can use Excel for a practical energy audit by organizing utility bills, meter readings, building details, and equipment estimates, then calculating…