Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/34157

From BetaArchive Wiki

Multiplan: Definition of Error Values PSS ID Number: Q34157 Article last modified on 01-11-1991 PSS database name: D_MPlan

3.x 4.00 4.01 4.20



When a Multiplan function, operation, or reference is used incorrectly, an error value results. The Multiplan error values and their possible causes are as follows:

Error Value Cause ———– —–

  1. DIV/0! An attempt to divide by 0 #N/A An unavailable value #NAME? An undefined name reference #NULL Specification of an intersection of disjoint areas; for example, R1R2 #NUM! An overflow because a number is too large or too small, or illegal use of an arithmetic function #REF! A relative reference reaching outside the worksheet, or a reference to a deleted or undefined area #VALUE! Text where a number is needed or vice versa, or a reference in an illegal context when a value is needed

Copyright Microsoft Corporation 1991.