Category: Formulas

Formula Tips and Tutorials for Excel – Functions and Formulas Explained with Examples

IFS Function

With IFS Function you don’t need to deal with nested IF functions anymore. IFS is an if function that can take multiple conditions.

Vlookup Errors

In this article, we are going to explain common Vlookup errors and how to correct them with easy adjustments.

Round Hours In Excel

There is a function you can use to round hours in Excel if you don’t want to display only full hours. Here is how to...

Evaluate Formula

Evaluate formula tool helps you figure out what is wrong with your formula. When you are confused about a formula in a worksheet, or is...

Exclude Values in Sumif

Have you ever needed to exclude values in sumif function? This article will show you how to do it.