The following functions are recalculated each time the worksheet changes, and can cause the Evaluate Formula tool to give results different from what appears in the cell: RAND, OFFSET, CELL, INDIRECT, NOW, TODAY, RANDBETWEEN, INFO, and SUMIF (in some scenarios).In addition, there are functions that can give different results each time and that will confuse Evaluate Formula. If a reference is blank, a zero value (0) is displayed in the Evaluation box.Some parts of formulas that use the IF and CHOOSE functions are not evaluated, and #N/A is displayed in the Evaluation box.There are some situations where Evaluate Formula either doesn’t work or might give unexpected results. If the same reference appears more than once in a formula, you can only ‘Step in’ to the first reference.Įvaluated parts could be highlighted so customers don’t have to squint to see the italics.The reference has to be in the same workbook.
0 Comments
Leave a Reply. |