Microsoft KB Archive/24408

Multiplan: Displaying Negative Dollar Amounts PSS ID Number: Q24408 Article last modified on 01-16-1991 PSS database name: D_MPlan

3.02 3.04 4.00 4.01 4.20

MS-DOS

Question:

I want to display negative dollar amounts without the currency symbol to get more on a printed page, for example, (1.00) instead of ($1.00). How can I do this?

Response:

This capability is not directly available in Multiplan version 3.02, but this capability has been incorporated in Multiplan versions 3.04, 4.00, 4.01, and 4.20.

In Multiplan version 3.02, this can be accomplished by using the following formula. The numbers in the far left column are the numbers to be centered (the width of this column should be 0). The formula in the center gives the modified display as shown on the far right:

100 IF(RC[-1]>0,RC[-1],“(”&FIXED(ABS(RC[-1]),2)&“)”) $100.00 -200 IF(RC[-1]>0,RC[-1],“(”&FIXED(ABS(RC[-1]),2)&“)”) (200.00)

If you use the numbers in the input column for any further calculations, the appearance of the negative numbers as text should not have an impact on the rest of the spreadsheet. With the column hidden with a width of 0, you are able to do the following:


 * Display the numbers as you want.
 * Print more on a line.
 * Retain the capability to use the original number in further calculations.

Copyright Microsoft Corporation 1991.