Professor Excel
if, iferror, ifna, ifs, thumbnail

IF Formula in Excel: Everything You Need to Know

The IF formula is one of the most useful formulas in Excel. It is highly adjustable and can be extended by other formulas easily. But many Excel users don’t really know all it’s secrets. Do you know how to use it? This article covers everything you need to know about it: How to use it, how to extend it and how to use the related formulas IFNA, IFERROR and the new formula IFS. […]

IFERROR: How to Handle Error Messages in Excel

When your formula produces an error in Excel – for example #N/A or #VALUE? – you got two options: Solve the error or use it in your calculation. Solving is usually a good idea but not always possible. So let’s take a look at how to deal with errors in Excel formulas using the IFERROR formula.