SIN Function in Excel: Sine of an Angle
MathLevel: IntermediateAvailable in: Excel 2007+SIN expects radians. Wrap degrees in RADIANS().Syntax=SIN(number)ArgumentWhat it meansnumberAngle in.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
RADIANS Function in Excel: Degrees to Radians
RADIANS Function in Excel: Degrees to Radians
MathLevel: IntermediateAvailable in: Excel 2007+RADIANS converts degrees, because SIN, COS and TAN in Excel expect.
Read article →FDIST Function in Excel: F Probability (Older Name)
FDIST Function in Excel: F Probability (Older Name)
FDIST returns the right-tailed F probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache
TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache
Split codes, names, addresses and emails in Excel 365 with TEXTSPLIT, TEXTBEFORE and TEXTAFTER: delimiters, instance numbers, multiple delimiters, rows vs columns, missing values…
Read article →FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)
FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)
FLOOR.PRECISE rounds down to a multiple regardless of signs; negatives round away from zero.
Read article →REPLACEB Function in Excel: Replace by Bytes
REPLACEB Function in Excel: Replace by Bytes
TextLevel: ExpertAvailable in: Excel 2007+REPLACEB is the byte-based version of REPLACE.Syntax=REPLACEB(text,1,2,"**")ArgumentWhat it meanstextText to.
Read article →ROWS Function in Excel: How Many Rows in a Range
ROWS Function in Excel: How Many Rows in a Range
ROWS counts the rows in a range or array — the classic helper for top-N lists that fill down.
Read article →Count Unique Values With Criteria in Excel (365 and Older Versions)
Count Unique Values With Criteria in Excel (365 and Older Versions)
How many different customers bought in North? How many distinct products did Asha sell? Count unique values with UNIQUE+FILTER, SUMPRODUCT+COUNTIFS for older Excel, and…
Read article →LOGINV Function in Excel: Inverse Lognormal (Older Name)
LOGINV Function in Excel: Inverse Lognormal (Older Name)
LOGINV returns the value at a lognormal probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Understand Excel 365 dynamic arrays: spilling results, the # spill reference, FILTER with AND/OR, SORT and SORTBY, UNIQUE counts, SEQUENCE, LET, and fixing #SPILL!…
Read article →Conditional Formatting with Formulas: 10 Rules Worth Knowing
Conditional Formatting with Formulas: 10 Rules Worth Knowing
Ten formula-based conditional formatting rules for real reports: highlight whole rows, overdue dates, duplicates, top N, weekends, missing values and differences between lists.
Read article →COUPDAYS Function in Excel: Days in the Current Coupon Period
COUPDAYS Function in Excel: Days in the Current Coupon Period
COUPDAYS returns the number of days in the coupon period that contains settlement. Used for bond pricing and accrued interest on half-yearly coupons.
Read article →