Microsoft KB Archive/103678

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


Article ID: 103678

Article Last Modified on 11/15/2004



APPLIES TO

  • Microsoft Works 2.0 Standard Edition
  • Microsoft Works 2.0a
  • Microsoft Works 3.0 Standard Edition
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5 Standard Edition
  • Microsoft Works 4.5a
  • Microsoft Works 4.0 Standard Edition
  • Microsoft Works 4.0a



This article was previously published under Q103678

SUMMARY

A nested IF statement (an IF statement within another IF statement) is used when determining if multiple conditions are true or false. For example, in an IF statement you are replacing the ValueIfTrue and/or the ValueIFFalse with another IF statement.

An IF statement or nested IF statement can be used in the Spreadsheet or Database module of Works for Windows.

Example of a Nested IF Statement

Suppose you wanted to assign a value to cell C1 based on the values listed in cell A1 and the values in cell A1 had to meet the following conditions:

   Condition               Result
   ------------------------------

  IF   A1<10           Then   150
       A1<25                  200
       A1<50                  250
       A1<75                  300
  Else Zero (0)
                

You would enter the following nested IF statement in cell C1:

=IF(A1<10,150,IF(A1<25,200,IF(A1<50,250,IF(A1<75,300,0))))


If the value in cell A1 were 32, the result of the formula would be 250.

NOTE: When using a nested IF statement in the Database module, replace the cell references with the actual field names.

REFERENCES

For more information about how to perform this task in Works for Windows 95, see your Works printed documentation or online Help.

"Microsoft Works for Windows User's Guide," version 3.0 pages 540-541

"Microsoft Works for Windows User's Guide," version 2.0 page 381


Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a ss db functions function w_works

Keywords: kbinfo KB103678