Microsoft KB Archive/51951: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - ">" to ">") |
||
| Line 13: | Line 13: | ||
The formula in cell A5 of the macro listed on page 113 of the "Microsoft Excel: Functions and Macros" manual does not perform the desired logical function. The correct formula should be as follows: | The formula in cell A5 of the macro listed on page 113 of the "Microsoft Excel: Functions and Macros" manual does not perform the desired logical function. The correct formula should be as follows: | ||
<pre> =IF(A4 | <pre> =IF(A4>1,GOTO(A13),IF(AND(A2>1,A3>1),GOTO(A13))) | ||
</pre> | </pre> | ||
The original formula will cause a #REF! error when a discontinuous area is active at the time the macro is run. | The original formula will cause a #REF! error when a discontinuous area is active at the time the macro is run. | ||
Latest revision as of 10:19, 21 July 2020
Excel: Macro Incorrect on Page 113 of Functions and MacrosLast reviewed: November 1, 1994 |
SUMMARYThe formula in cell A5 of the macro listed on page 113 of the "Microsoft Excel: Functions and Macros" manual does not perform the desired logical function. The correct formula should be as follows: =IF(A4>1,GOTO(A13),IF(AND(A2>1,A3>1),GOTO(A13))) The original formula will cause a #REF! error when a discontinuous area is active at the time the macro is run. |
KBCategory: kbother Last reviewed: November 1, 1994 |
