INT Function in Excel: Whole Number Part (Rounds Down)
INT rounds a number down to the nearest integer. On dates with times, it strips the time.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
IF Function in Excel: Make Decisions in a Formula
IF Function in Excel: Make Decisions in a Formula
IF checks a condition and returns one value if it is TRUE and another if it is FALSE.
Read article →ROUNDDOWN Function in Excel: Always Round Towards Zero
ROUNDDOWN Function in Excel: Always Round Towards Zero
ROUNDDOWN removes digits without rounding up — for example to calculate completed years or whole units.
Read article →ABS Function in Excel: Absolute Value (Remove the Minus Sign)
ABS Function in Excel: Absolute Value (Remove the Minus Sign)
MathLevel: BeginnerAvailable in: Excel 2007+ABS returns a number without its sign: −250 becomes 250.Syntax=ABS(number)ArgumentWhat it meansnumberAny.
Read article →ROUNDUP Function in Excel: Always Round Away From Zero
ROUNDUP Function in Excel: Always Round Away From Zero
ROUNDUP always rounds up (away from zero); ROUNDDOWN always rounds down. Useful for packing, billing and slabs.
Read article →ROUND Function in Excel: Round to Any Number of Digits
ROUND Function in Excel: Round to Any Number of Digits
ROUND rounds a number to a given number of digits. Unlike cell formatting, it changes the actual value — important for invoices and totals…
Read article →MAX Function in Excel: Largest Value in a Range
MAX Function in Excel: Largest Value in a Range
StatisticalLevel: BeginnerAvailable in: Excel 2007+MAX returns the largest number. MIN is its mirror. Both ignore text and blanks.Syntax=MAX(number1.
Read article →COUNTA Function in Excel: Count Non-Empty Cells
COUNTA Function in Excel: Count Non-Empty Cells
Count the number of non-empty cells in a range, tallying numbers, text strings, dates, boolean values, and error codes.
Read article →COUNT Function in Excel: Count Cells That Contain Numbers
COUNT Function in Excel: Count Cells That Contain Numbers
Count the number of cells in a range or argument list that contain numbers, including positive/negative values, decimals, and dates.
Read article →AVERAGE Function in Excel: Arithmetic Mean of Numbers
AVERAGE Function in Excel: Arithmetic Mean of Numbers
AVERAGE returns the arithmetic mean: the sum divided by the count of numbers. Empty cells and text are ignored, but zeros are counted.
Read article →SUM Function in Excel: Add Numbers, Ranges and Whole Columns
SUM Function in Excel: Add Numbers, Ranges and Whole Columns
SUM adds numbers, cell references and ranges. It ignores text and empty cells, which makes it the safest way to total a column.
Read article →