When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

1] Use formula suggestions or Function Wizard to avoid syntax errors Microsoft Excel displays a list of matching formulas as soon as you start typing the function in the function bar.

How to Isolate a Value in Excel. Isolating values in an Excel 2007/2010 worksheet or workbook is common in both error-checking and data analysis tasks. While appropriate even for a small worksheet ...