Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to retrieve first match between two ranges in Excel
  • Left Lookup in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • How to get first row number in range in Excel
  • To count total rows in a range in Excel

Data Analysis Examples

  • How to add Trendline to a chart in Excel
  • How to count table columns in Excel
  • Data Series in Excel
  • How to calculate current stock or inventory in Excel
  • Conditional Formatting Data bars Examples in Excel

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation date in specific year
  • Excel Data validation exists in list
  • Excel Data validation unique values only
  • Excel Data validation only dates between

Category: Math and Trig Functions

Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.

How to Sum Range with Errors in Excel

by

This example shows you how to create an array formula that sums a range with errors. You can also use the AGGREGATE function to sum a range with errors. 1. We use the IFERROR function to check for an error. Explanation: the IFERROR function returns 0, if an error is found. If not, it returns the value of the cell. …

Continue Reading

SUMIF function in Excel

by

The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples. Numbers 1. The SUMIF function below (two arguments) sums values in the range A1:A5 that are less than or equal to 10. 2. The following SUMIF function gives the exact same result. It uses the & operator to …

Continue Reading

RAND vs RANDBETWEEN function examples in Excel

by

Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function. Rand The RAND function generates a random decimal number between 0 and 1. 1. Select cell A1. 2. Type RAND() and press Enter. The RAND function has no arguments. 3. To generate a list of random numbers, select cell A1, click on …

Continue Reading

Round numbers in Excel

by

This chapter illustrates three Mathematical functions ROUND, ROUNDUP and ROUNDDOWN. Navigation: Formula Tab → Function Library Group → Math & Trig Category Before your start: if you round a number, you lose precision. If you don’t want this, show fewer decimal places without changing the number itself. Round Syntax: ROUND(number, num_digits) 1. Round a number to two decimal places. …

Continue Reading

Count and Sum Functions in Excel

by

The most used functions in Excel are the functions that count and sum. COUNT function is one of the STATISTICAL functions while SUM function is one of the Math and Trig functions. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells that contain numbers, use the COUNT function. Countif To count cells …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2
  • 3
  • 4

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Add line break based on OS in Excel
  • CONCAT function: Description, Usage, Syntax, Examples and Explanation
  • Convert text to numbers using VALUE function in Excel
  • Convert Numbers to Text in Excel
  • How to get page from URL in Excel
  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • How to get number of days, weeks, months or years between two dates in Excel
  • How to calculate workdays per month in Excel
  • Basic timesheet formula with breaks in Excel
  • How to calculate nth day of week in month in Excel
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • Calculate original loan amount in Excel
  • ODDLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • Bond valuation example in Excel
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles