Microsoft KB Archive/30270

Round Formula Error in “Putting Microsoft Works to Work”

PSS ID Number: Q30270 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SUMMARY =

An error appears on Page 146 of Microsoft Press’s “Putting Microsoft Works to Work” when listing a round formula to use in a template.

This formula error generates an “Invalid reference” or “Wrong number of arguments” error message.

To correct the formula, replace the equal sign (=) with a greater than sign (>) after C9 in each of the IF statements.

The formula should read as follows:

=ROUND(C9*2, IF(C9>10000000,-7, IF(C9>1000000,-6, IF(C9>100000,-5, IF(C9>10000,-4, IF(C9>1000,-3, IF(C9>100,-2, IF(C9>10,-1, C9))))))))

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.