Detect errors in formulas - Microsoft Support

You can use error checking to detect errors in formulas. The rules don't guarantee error-free worksheets, but they can help find common mistakes. Errors can include: Cells containing formulas that result in an error, inconsistent calculated column formula in tables, cells containing years represented as 2 digits, numbers formatted as text or preceded by an apostrophe, formulas inconsistent with other formulas in the region, formulas which omit cells in a region, unlocked cells containing formulas, formulas referring to empty cells, and data entered in a table is invalid.

IFS function - Microsoft Support

Detect errors in formulas - Microsoft Support

Detect errors in formulas - Microsoft Support

How to correct a #VALUE! error in the IF function - Microsoft Support

How to correct a #NAME? error - Microsoft Support

Troubleshooting formulas

UNIQUE function - Microsoft Support

What Are Excel Errors and How To Fix Them? - Shiksha Online

NOT function - Microsoft Support

How to correct a #CALC! error - Microsoft Support

Use Excel with earlier versions of Excel - Microsoft Support

Please Help to find the formula - Microsoft Community Hub

How to Find Errors in Excel – Formula Errors - Earn & Excel

FILTER function - Microsoft Support

Detect errors in formulas - Microsoft Support