Editing Content :: Admin Scraper

Chapter

Content type

Position

Value

Spreadsheet ▪ Using an unacceptable argument in a function that requires a numeric argument. ▪ Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) used in the function are numbers. For example, even if the value we want to enter is $1,000, enter 1000 in the formula. ▪ Using a worksheet function that iterates, such as IRR or RATE, and the function cannot find a result. ▪ Use a different starting value for the worksheet function. ▪ Change the number of times Microsoft Office Excel iterates formulas. 1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category. 2. In the Calculation options section, select the Enable iterative calculations check box. 3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet. 4. To set the maximum amount of change that we will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet. Entering a formula that produces a number that is too large or too small to be represented in Excel. • Correct a #REF! Error This error occurs when a cell reference (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.) is not valid. 1. Optionally, click the cell that displays the error, click the button that appears, and then click Show Calculation Steps if it appears. 2. Review the following possible causes and solutions: ▪ Deleting cells referred to by other formulas, or pasting moved cells over cells referred to by other formulas. ▪ Change the formulas, or restore the cells on the worksheet by clicking Undo immediately after we delete or paste the cells. ▪ Using an Object Linking and Embedding (OLE) link to a program that is not running. 77 ▪ Start the program. Reprint 2026-27