Microsoft KB Archive/61466

Mac Works: Activating Functions on or After a Particular Date

PSS ID Number: Q61466 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0

MACINTOSH

=
========================================================= 1.00 1.10 2.00 3.00 MACINTOSH kbother

= SUMMARY =

In Works, to activate spreadsheet functions on or after the current date, use the following formula

=IF(A1<=NOW,Function,0)

where “A1” is the cell containing the date on which the function is to be activated and Function is the calculation to be figured.

The IF statement compares the date in cell A1 to the current date, which is generated by the NOW function. If the current date is greater than or equal to the date in A1, the formula is calculated; otherwise, the cell equals 0 (zero).

For example, if you wanted to formula to perform a calculation on dates that are prior to the current date, you would use this function.

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 1.00 1.10 2.00 3.00 mwksss

=
========================================================= Version : 1.0 1.1 2.0 3.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.