ROW Function in Excel: Row Number of a Cell
ROW returns the row number of a reference (or of the cell it is in). It is the quiet engine behind serial numbers and…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
IFS Function in Excel: Several Conditions Without Nested IFs
IFS Function in Excel: Several Conditions Without Nested IFs
IFS checks conditions in order and returns the value for the first TRUE one — cleaner than nesting IF inside IF.
Read article →OCT2HEX Function in Excel: Octal to Hexadecimal
OCT2HEX Function in Excel: Octal to Hexadecimal
OCT2HEX converts a octal number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →ISODD Function in Excel: Is the Number Odd?
ISODD Function in Excel: Is the Number Odd?
InformationLevel: BeginnerAvailable in: Excel 2007+ISODD returns TRUE for odd numbers (decimals are truncated first).Syntax=ISODD(number)ArgumentWhat it.
Read article →SEQUENCE Function in Excel: Generate a List of Numbers or Dates
SEQUENCE Function in Excel: Generate a List of Numbers or Dates
SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.
Read article →OCT2BIN Function in Excel: Octal to Binary
OCT2BIN Function in Excel: Octal to Binary
OCT2BIN converts a octal number to binary. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →Nested IF, AND, OR and IFERROR: Decision Formulas Without the Headache
Nested IF, AND, OR and IFERROR: Decision Formulas Without the Headache
Write decision formulas that stay readable: nested IF in the right order, IFS, AND/OR combinations, SWITCH, lookup tables instead of deep nesting, and IFERROR/IFNA…
Read article →HEX2DEC Function in Excel: Hexadecimal to Decimal
HEX2DEC Function in Excel: Hexadecimal to Decimal
EngineeringLevel: IntermediateAvailable in: Excel 2007+HEX2DEC reads hex text — colour codes, error codes from logs — as a.
Read article →DECIMAL Function in Excel: Any Base Back to a Number
DECIMAL Function in Excel: Any Base Back to a Number
EngineeringLevel: IntermediateAvailable in: Excel 2013+DECIMAL reverses BASE.Syntax=DECIMAL(text, radix)ArgumentWhat it meansradix2 to 36.ExamplesExample.
Read article →BASE Function in Excel: Number in Any Base
BASE Function in Excel: Number in Any Base
BASE converts to any base from 2 to 36 and handles much bigger numbers than DEC2BIN.
Read article →Excel Solver: Find the Best Answer (Budgets, Staffing, Product Mix)
Excel Solver: Find the Best Answer (Budgets, Staffing, Product Mix)
Use Excel Solver to find the best plan under limits: set up the model, choose the objective, changing cells and constraints, pick the right…
Read article →Rank in Excel: Handle Ties and Rank Within Each Group
Rank in Excel: Handle Ties and Rank Within Each Group
RANK.EQ vs RANK.AVG, unique ranks with no ties, dense ranking, and ranking within each region or month using COUNTIFS — with a leaderboard example…
Read article →