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, SAP, Oracle & automation tips — plus wacky facts
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 →IFS checks conditions in order and returns the value for the first TRUE one — cleaner than nesting IF inside IF.
Read article →OCT2HEX converts a octal number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →Learn SQL from the very beginning: tables, SELECT, WHERE, ORDER BY, aggregates, GROUP BY, JOINs, NULLs, subqueries, CTEs, window functions and changing data —…
Read article →InformationLevel: BeginnerAvailable in: Excel 2007+ISODD returns TRUE for odd numbers (decimals are truncated first).Syntax=ISODD(number)ArgumentWhat it.
Read article →SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.
Read article →OCT2BIN converts a octal number to binary. Used for device codes, permission bits, memory addresses and number-system lessons.
Read article →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 →EngineeringLevel: IntermediateAvailable in: Excel 2007+HEX2DEC reads hex text — colour codes, error codes from logs — as a.
Read article →EngineeringLevel: IntermediateAvailable in: Excel 2013+DECIMAL reverses BASE.Syntax=DECIMAL(text, radix)ArgumentWhat it meansradix2 to 36.ExamplesExample.
Read article →BASE converts to any base from 2 to 36 and handles much bigger numbers than DEC2BIN.
Read article →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 →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.