Microsoft KB Archive/40112: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (X010 moved page Microsoft KB Archive/Q40112 to Microsoft KB Archive/40112 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
 
(No difference)

Latest revision as of 19:22, 12 August 2020

Avoiding the Multiplan “#VALUE” Error when Adding Cells PSS ID Number: Q40112 Article last modified on 01-10-1989 PSS database name: D_MPlan

3.x 4.00

MS-DOS

Summary:

A “#Value” error will be returned in the cell that contains a formula that adds cells together if one of the cells to be added has text in it.

To avoid this message, use the SUM() function to add the cell values. The SUM() function will overlook text, whereas the + (PLUS SIGN) will not.

Copyright Microsoft Corporation 1989.