Posts Tagged 'Excel functions', page 7
How to calculate compound interest in Excel - formula for daily, monthly, yearly compounding
The tutorial explains the compound interest formula for Excel and provides examples of how to calculate the future value of the investment at annual, monthly or daily compounding interest rate. You will also find the detailed steps to create your own Excel compound interest calculator. Continue reading
Using logical functions in Excel: AND, OR, XOR and NOT
Last week we tapped into the insight of Excel logical operators that are used to compare data in different cells. Today, you will see how to extend the use of logical operators and construct more elaborate logical tests to perform more complex calculations and more powerful data analysis. Excel logical functions such as AND, OR, XOR and NOT will help you in doing this. Continue reading
Excel logical operators: equal to, not equal to, greater than, less than
Many tasks you perform in Excel involve comparing data in different cells. For this, Microsoft Excel provides six logical operators, which are also called comparison operators. This tutorial aims to help you understand the insight of Excel logical operators and write the most efficient formulas for your data analysis. Continue reading
Excel IF statement with multiple AND/OR conditions, nested IF formulas, and more
The tutorial provides a variety of advanced IF formula examples that demonstrate how to use the Excel IF function with other functions, make nested IF formulas with multiple conditions, use IFERROR and IFNA. Continue reading
Using IF function in Excel: formulas for numbers, text, dates, blank cells
In this tutorial, we are going to learn the syntax and common usages of Excel IF function as well as discuss a few formula examples for text, dates and numbers that will hopefully prove helpful both to beginners and experienced Excel users. Continue reading
How to use Excel SUMIFS and SUMIF with multiple criteria - formula examples
This tutorial explains the difference between the SUMIF and SUMIFS functions in terms of their syntax and usage, and provides a number of formula examples to sum values with multiple AND / OR criteria in Excel 2016, 2013, 2010, and lower. Continue reading
How to use SUMIF in Excel - formula examples to conditionally sum cells
This tutorial explains the Excel SUMIF function in plain English and provides a numbers of SUMIF formula examples of Excel conditional sum for numbers, text, dates and wildcards. Continue reading
5 ways to sum a column in Excel 2016 - 2010
This tutorial shows how to sum a column in Excel 2010-2013. Try out 5 different ways to total columns: find the sum of the selected cells on the Status bar, use AutoSum in Excel to sum all or only filtered cells, employ the SUM function or convert your range to Table for easy calculations. Continue reading
Convert text-formatted digits to number using Excel VALUE function and other options
In this article, I'll show you how to convert text digits to number using several options in Excel 2010-2013. You'll see how to make Excel treat digits as numbers with the help of the VALUE function, error checking, Paste Special and applying the number format. Those who want to automate the task will find a helpful VBA macro and a special add-in. Continue reading
How to convert numbers to text using Excel TEXT function and other options
This tutorial shows how to convert number to text in Excel 2016 - 2010. See how to accomplish the task with the Excel TEXT function and use number to string to specify the formatting. Learn how to change number format to text with the Format Cells… and Text to Columns options. Continue reading
Excel VLOOKUP not working - solutions for N/A, NAME and VALUE errors
The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel, troubleshoot and fix common errors and overcome VLOOKUP's limitations. Continue reading
4 ways to do a case-sensitive vlookup in Excel
The tutorial explains how to make Excel VLOOKUP case-sensitive, demonstrates a few other formulas that can look up case in Excel and points out strengths and limitations of each function. Continue reading
INDEX & MATCH in Excel - better alternative to VLOOKUP
This tutorial demonstrates the key strengths of Excel's INDEX / MATCH function that make it superior to VLOOKUP. You will find a number of formula examples that will help you easily cope with many complex tasks when VLOOKUP fails. Continue reading
How to use VLOOKUP & SUM or SUMIF functions in Excel
In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria. Continue reading
How to use VLOOKUP in Excel: advanced formula examples
In this VLOOKUP tutorial, you will find a number of advanced formula examples that demonstrate how to look up with multiple criteria, use two VLOOKUP functions in one formula, dynamically pull data from different sheets, and more. Continue reading
Excel VLOOKUP tutorial for beginners with formula examples
This VLOOKUP tutorial explains the syntax and provides a number of examples that illustrate the most common usages of the VLOOKUP function in Excel. Continue reading
How to use Excel COUNTIFS and COUNTIF with multiple criteria
The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. Continue reading
COUNTIF in Excel - count if not blank, greater than, duplicate or unique
The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading
3 ways to count empty cells in Excel
If your task is to get Excel count blank cells in your worksheet, read this article to find 3 ways to accomplish it. Learn how to search and select empty cells with the Go to Special option, use Find and Replace to count blanks or enter a formula in Excel 2010-2013. Continue reading
How to count non-empty cells in Excel 2010, 2013
This articles looks at the ways to count non-blank cells in Excel 2010-2013. Below you'll find 3 methods for counting non-blanks: see the number on the Excel Status bar, employ the Find and Replace dialog or use a special formula. Continue reading
