Formulas & functions
How a function works, with worked examples you can paste.
- SUBTOTAL Formula in Excel: How to Apply It Step by StepTo apply a subtotal formula in Excel, choose what you want to calculate and enter =SUBTOTAL(9,B2:B7) in the total cell when your…
- Arduino Functions: How to Write and Use Them in a SketchTo write a function in Arduino, give it a return type and name, add any input parameters in parentheses, and put its…
- Excel Split Function: How TEXTSPLIT Evaluates TextExcel does not have a worksheet function named SPLIT; in Microsoft 365, use TEXTSPLIT to divide text at a chosen delimiter. For…
- Excel LOG and String Functions: Meaning and ExamplesIn Excel, LOG calculates a number’s logarithm; it does not record or save text messages. To build or edit log strings, use…
- Split S2 into K Equal Parts in Excel: Formula GuideTo split the numeric value in Excel cell S2 into k equal parts, divide it by the number of parts: if T2…
- SUBTOTAL Formula for Filtered Cells in Excel: GuideTo total only the rows currently visible after filtering in Excel, use =SUBTOTAL(9,B2:B6), replacing the range with your data. SUBTOTAL automatically ignores…
- Arduino Built-In Functions: What They Do and How to Use ThemArduino built-in functions are the core commands and routines used to control a board, read inputs, produce outputs, manage time, and communicate…
- Excel Split Function: Using TEXTSPLIT to Separate TextIf you mean the split function in Excel, use TEXTSPLIT in Microsoft 365 or Excel 2024 to divide text at a delimiter,…
- String Functions in SQL: Common Uses, Syntax, and ExamplesSQL string functions work with text: they can join values, change letter case, remove unwanted spaces, extract part of a string, or…
- Balance of Payments Equation: Formula and Key TermsThe balance of payments equation records a country’s transactions with the rest of the world: current account + capital account = financial…
- SUBTOTAL Formula for Visible Cells in Excel: How It WorksTo calculate a total for visible rows in Excel, use =SUBTOTAL(109,B2:B100), replacing the range with your data. The 109 tells Excel to…
- PostgreSQL Window Functions: Queries, Frames, and ExamplesPostgreSQL window functions calculate a result across related rows while keeping each row in the query result. Use an OVER clause to…
- Arduino String Functions: Methods, Examples, and TipsArduino String functions are methods and operators for storing, joining, searching, editing, and converting text in an Arduino sketch. The capitalized String…
- String Function: Meaning, Examples, and Excel UsesA string function is a function that works with text made up of characters: it might count, extract, search, replace, join, or…
- Python split() Function: How to Split Strings with ExamplesUse Python’s string method split() to turn one string into a list of smaller strings. Call text.split() to split on runs of…
- Power Automate String Functions and Practical ExamplesPower Automate string functions let you build, inspect, split, clean, and compare text inside a flow. Add an action such as Compose,…
- Excel Log Functions: How to Use LOG, LOG10, and LNTo integrate logarithm functions into an Excel worksheet, enter LOG, LOG10, or LN in a cell formula, point the function at a…
- Compare Values on Two Excel Sheets: Formulas and MethodsTo compare values in the same positions on two Excel sheets, enter a formula such as =IF(Sheet1!A2=Sheet2!A2,"Match","Different") in a results column and…
- Excel SPLIT Function: Use TEXTSPLIT to Separate TextExcel does not have a function named SPLIT. In Microsoft 365 or Excel 2024, use TEXTSPLIT to divide text at a delimiter…
- JavaScript String Functions: Methods, Examples, and UsesJavaScript string functions are built-in methods and properties for working with text: finding words, extracting parts, changing letter case, replacing content, and…
- Excell Battery Canada: How to Find the Right BatteryIf you are searching for an Excell battery in Canada, first check whether the name on the product is Exell (one c,…
- SUBTOTAL Formula Usage in Excel: Filters and ExamplesIn Excel, use the SUBTOTAL formula to calculate a sum, average, count, or other summary while automatically ignoring rows excluded by a…
- Logical Functions in Tableau: IF, CASE, and NULLsLogical functions in Tableau evaluate conditions and return results such as a label, number, or Boolean value (TRUE or FALSE). The main…
- Amex Split Function: Why Use It for Shared PurchasesUse the Amex Split function to ask friends or family to reimburse their share of an eligible purchase charged to your American…
- PostgreSQL String Functions and Operators: Practical GuidePostgreSQL string functions and operators let you join, inspect, extract, search, and transform text in SQL. The main tools include the ||…
- Balance Sheet Equation: Meaning, Formula, and ExamplesThe balance sheet equation is Assets = Liabilities + Equity. It means that everything a business owns or controls is financed either…
- Excell Battery SDS: How to Find the Right SheetAn Excell battery does not have one universal SDS: the correct safety data sheet depends on the battery’s exact model and chemistry.…
- Databricks Built-In Functions: Types and ExamplesDatabricks built-in functions are ready-made operations for querying and transforming data with Databricks SQL and Apache Spark SQL. They cover common tasks…
- Excel SUBTOTAL With COUNTIF: Count Visible MatchesTo count rows that match a condition and remain visible after filtering, combine SUBTOTAL with SUMPRODUCT; COUNTIF by itself counts filtered-out rows…
- Oracle String Functions Explained with ExamplesOracle string functions operate on character data in SQL and PL/SQL. For everyday work, use functions such as SUBSTR to extract text,…