TRUNC Function in Excel: Cut Off Decimals Without Rounding
TRUNC drops digits after a given point, moving towards zero. Unlike INT, TRUNC(−8.9) is −8.
Read article →Math & Trig
Excel Math & Trig functions explained with syntax, examples and common mistakes.
QUOTIENT Function in Excel: Whole-Number Division
QUOTIENT Function in Excel: Whole-Number Division
QUOTIENT returns only the integer part of a division; MOD returns the remainder.
Read article →MOD Function in Excel: Remainder After Division
MOD Function in Excel: Remainder After Division
MOD returns the remainder after dividing. Great for alternating rows, cycles and time differences over midnight.
Read article →MROUND Function in Excel: Round to the Nearest Multiple
MROUND Function in Excel: Round to the Nearest Multiple
MROUND rounds to the nearest multiple you choose — prices to ₹5, times to 15 minutes.
Read article →SUMIF Function in Excel: Sum Values That Meet One Condition
SUMIF Function in Excel: Sum Values That Meet One Condition
SUMIF adds values where one condition is true. For two or more conditions use SUMIFS.
Read article →INT Function in Excel: Whole Number Part (Rounds Down)
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 →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 →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 →