To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
Absolute and relative cell references, and ranges in Excel
Remove blank cells in a list of values in Excel using Advanced Filter, retaining the original list.
How to use the VLOOKUP function in Excel
How to display today’s date and time in Microsoft Excel
How to display today’s date in Microsoft Excel
How to protect your Microsoft Excel workbook so that users can only view the worksheets you want them to, and data and workbook structure can’t be changed.
If you’re new to Microsoft Excel, or to any function software for that matter, there are a few basic approaches to take
Welcome to the new Excel Quick Help website giving free help for Microsoft Excel 2016!
Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation