FIXED Function in Excel: Round and Format as Text
FIXED rounds a number and returns it as text with or without thousands separators — good for sentences built from numbers.
Read article →Excel, SAP, Oracle & automation tips — plus wacky facts
FIXED rounds a number and returns it as text with or without thousands separators — good for sentences built from numbers.
Read article →Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…
Read article →ISERROR returns TRUE for any error value. It is mostly used in conditional formatting and checks; for replacing errors, IFERROR is simpler.
Read article →DatabaseLevel: ExpertAvailable in: Excel 2007+DMIN is DMAX’s twin: the smallest value among matching rows.Syntax=DMIN(database, field.
Read article →DMAX returns the largest value in a column among matching rows. It worked in every Excel version long before MAXIFS existed.
Read article →StatisticalLevel: IntermediateAvailable in: Excel 2019+MINIFS returns the minimum of values where all conditions are true.Syntax=MINIFS(min_range.
Read article →MathLevel: BeginnerAvailable in: Excel 2007+PRODUCT multiplies all numbers in its arguments, ignoring text and blanks.Syntax=PRODUCT(number1, [number2].
Read article →Turn a wide report with Jan–Dec columns into a tidy Month/Value table using Power Query’s Unpivot — so pivot tables, charts and SUMIFS finally…
Read article →MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.
Read article →SUMSQ squares each value and adds them up — the building block of error measures such as RMSE.
Read article →AGGREGATE is like SUBTOTAL with 19 functions and extra options — most usefully, ignoring error values such as #N/A in the range.
Read article →SUBTOTAL calculates a sum, count, average and more while ignoring rows hidden by a filter. It also ignores other SUBTOTALs in the range, so…
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.