Microsoft KB Archive/58033

Microsoft Knowledge Base

File: Conditional IF Statements in Calculated Fields

Last reviewed: October 27, 1994
Article ID: Q58033

Summary:

Microsoft File does not support the use of IF statements in calculated fields. The formula, however, can be made conditional depending on another field(s).

More Information:

Use binary notation in a conditional field (1 for yes, 0 for no) and use the number in that field as the "decision bits" in the formula. Two examples follow:

Suppose you have a field called Public and another called Due Date. If the company is public (Public = 1), the due date is 10 days from the start date; otherwise (Public = 0), the due date is 4 days from the start date. Start Date is another column, as in the following formula:

      =Start Date + 4 + (6*Public)

If the company is public, the result is Start Date +10; if it is not public, the result is Start Date + 4.

Salaried employees (Salaried = 1) accrue sick leave at 3.1 hours/week, and hourly employees (Salaried = 0) accrue sick leave at 1.6 hours/week. To show that value in a computed field, use the following formula:

      =1.6 + (Salaried*1.5)

Additional reference words: KBCategory: kbusage KBSubcategory: THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: October 27, 1994 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.