VALUE Function in Excel: Convert Text to a Number
VALUE turns text that looks like a number into a real number, so SUM and lookups work.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
CONFIDENCE.NORM Function in Excel: Margin of Error
CONFIDENCE.NORM Function in Excel: Margin of Error
CONFIDENCE.NORM gives the ± margin around a sample mean for a chosen confidence level.
Read article →Extract Numbers From Text in Excel (Invoice Numbers, Amounts, Phone Numbers)
Extract Numbers From Text in Excel (Invoice Numbers, Amounts, Phone Numbers)
Pull the numbers out of messy text like "INV-2026-0045", "Paid Rs 12,500 via UPI" or "Call 98765 43210" with TEXTJOIN+MID+SEQUENCE, REGEXEXTRACT, TEXTAFTER and Flash…
Read article →MODE.MULT Function in Excel: All the Most Common Values
MODE.MULT Function in Excel: All the Most Common Values
MODE.MULT returns every value tied for most frequent, where MODE.SNGL returns only the first.
Read article →NORM.INV Function in Excel: Value for a Given Probability
NORM.INV Function in Excel: Value for a Given Probability
NORM.INV is the reverse of NORM.DIST: give it a probability and it returns the value. Great for safety stock, and for simulations with RAND().
Read article →MODE.SNGL Function in Excel: The Most Frequent Number
MODE.SNGL Function in Excel: The Most Frequent Number
StatisticalLevel: IntermediateAvailable in: Excel 2010+MODE.SNGL returns the value that appears most often in a set of numbers.Syntax=MODE.SNGL(number1.
Read article →Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)
Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)
Computers store decimals in binary, so 0.1 + 0.2 becomes 0.30000000000000004. Why it happens, why Excel usually hides it and where it doesn’t (wrapped…
Read article →LET and LAMBDA: Write Your Own Excel Functions (No VBA)
LET and LAMBDA: Write Your Own Excel Functions (No VBA)
Use LET to name parts of long formulas and LAMBDA to create reusable custom functions like CLEANTEXT or FYEAR — saved in Name Manager,…
Read article →Excel’s Strangest Behaviours Explained: 15 “Bugs” That Are Actually Features
Excel’s Strangest Behaviours Explained: 15 “Bugs” That Are Actually Features
Why Excel turns 1-2 into a date, drops leading zeros, shows ####, changes long numbers to E+ notation, gives #SPILL!, auto-corrects gene names and…
Read article →TRUE Function in Excel: The Logical Value TRUE
TRUE Function in Excel: The Logical Value TRUE
TRUE() returns the logical value TRUE. You can also just type TRUE; the function form exists for compatibility.
Read article →ISLOGICAL Function in Excel: Is It TRUE or FALSE?
ISLOGICAL Function in Excel: Is It TRUE or FALSE?
ISLOGICAL checks whether a value is a real TRUE/FALSE. Imports often bring the text "TRUE", which looks identical but is not.
Read article →FALSE Function in Excel: The Logical Value FALSE
FALSE Function in Excel: The Logical Value FALSE
FALSE() returns the logical value FALSE, most often seen as the exact-match argument in VLOOKUP.
Read article →