How to use no SUBSTRING function in Excel
Nov 06, 2020
There's no SUBSTRING function in Excel.
How to use Substitute vs Replace in Excel
Nov 06, 2020
This example shows the difference between the SUBSTITUTE function and the REPLACE function.
How to use Sum Every nth Row in Excel
Nov 06, 2020
This example shows you how to create an array formula that sums every nth row in Excel.
How to use Sum Largest Numbers in Excel
Nov 06, 2020
This example shows you how to create an array formula that sums the largest numbers in a range.
How to use Sum Range with Errors in Excel
Nov 06, 2020
This example shows you how to create an array formula that sums a range with errors.
How to use Sum with Or Criteria in Excel
Nov 06, 2020
Summing with Or criteria in Excel can be tricky. This article shows several easy to follow examples.
How to use Switch function in Excel
Nov 06, 2020
This example teaches you how to use the SWITCH function in Excel 2016 or later instead of the IFS function.
How to use System of Linear Equations in Excel
Nov 06, 2020
This example shows you how to solve a system of linear equations in Excel.
How to use Tax Rates in Excel
Nov 06, 2020
This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.
How to use Text Function in Excel
Nov 06, 2020
When joining text and a number, use the TEXT function in Excel to format that number.