Summer Squash: 1 cup cooked/sliced/diced squash or 1 whole zucchini (7 to 8 inches long) or about 1/2 of a large yellow crookneck. Sweet Potato: 1 cup mashed or 1 large baked potato (about 2 1/4 inches in diameter) Fruit Servings That Equal a Cup.
Excel Iferror Function. The Excel Iferror function tests if an initial supplied value (or expression) returns an error, and if so, returns a second supplied argument; Otherwise the function returns the initial value. Note: the Iferror function is new to Excel 2007, so is not available in earlier versions of Excel. value.
1 Click OK in the Format Cells dialog box, and then click OK in the Conditional Formatting dialog box. 2  Note Because you selected column A in step 2, all the cells in column A were formatted with this conditional format. 3  Therefore, any other cells in column A that return error values will not display the error value.o hide the error value, you can change the formula in cell A1 to the following formula: In these examples, this formula returns the empty string (). In Microsoft Office Excel 2007, you can use the IFERROR function to simplify this formula, as follows: