#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and …

Select the Microsoft 365 or Office product you want to repair and select Modify. Note: This will repair the entire Office suite even if it's just one application you want to repair such as Word or …

If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook. If neither automatic nor manual repair works, there are some recovery methods that …

This topic provides help for the most common scenarios for the #VALUE! error in the IF function.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

When you open a workbook that has been corrupted, Excel automatically starts File Recovery mode and attempts to reopen and simultaneously repair the workbook.

This topic provides help for the most common scenarios for the #VALUE! error in the AVERAGE or SUM functions.

This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open …

To force Excel to run the Import Text Wizard, you can change the file name extension from .csv to .txt before you open it, or you can import a text file by connecting to it (for more information, …

Use a formula to subtract dates or Add or subtract time correctly to avoid negative date or time value results. Change negative formula results that are formatted as dates or times to a …