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.

How to Make Box & Whisker Plots in Excel 2007. Microsoft Excel, a spreadsheet and data analysis program, is available as a stand-alone program or as a component of the Microsoft Office ...

In the Maximum iterations box, type the number of times you want Excel to recalculate. The higher the number of iterations, the more time Excel needs to calculate the worksheet.

However, if the formula results in an error, IFERROR “takes over” and produces an alternative result. The alternatives could be text such as “Invalid,” “Not Found,” “Other,” or a number such as 0. You ...