The higher the number of iterations, the more time Excel needs to calculate the worksheet. In the Maximum Change box, type the amount of variation you will accept between calculation results.

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.