The next time you need to debug a complex Excel formulas, or just want to know that a reference in the formula for the value of the cell, try this: Select the cell containing the formula and press [F2] (or simply double-click The cell). Then, drag bright part of the equation or formula to check the cell references, press [F9] Excel will be dragged into the calculation of the brightest part of the replacement results. Press [Ctrl + Z] can be restored just replaced.
The same way you can replace the other parts of the error until you find the formula that results so far. (Press [F2] immediately after the press [F9], or drag over the entire formula by [F9].)
For example, suppose you selected contains the formula "Κ (12 × 12) / (1 + Rate) λA20 cell. press [F2], delayed light equation 12 × 12, and press [F9]. Excel that part of the formula Converted to 144. At this time, the formula becomes Κ (144) / (1 + Rate) λA20. Similarly, the delayed reference light cell A20, and press [F9], Excel will replace the values into the worksheet. When you are done Part of the formula calculation, if you want to retain the original formula, press [Esc], if you want to replace the formula, press [Enter]. You can also press [Ctrl + Z] to recover the changes.
没有评论:
发表评论