Related Topics:

Function Wizard Functions

Data Entry Tips for Functions

When entering functions in a spreadsheet, either manually or using the Function Wizard, keep the following guidelines in mind:

You can also enter the serial number directly. For example, YEAR(40828) returns 2011 (the serial date using the 1900 date system).

You can also use the results of other formulas or functions. In particular, you can use the NOW or TODAY functions to generate values on-the-fly. For example, if the current date is 10/24/2011, then MONTH(TODAY()) returns 10.

You can also enter the serial number directly. For example, MINUTE(0.78125) returns 45 (as the specified serial number represents 6:45 PM).

You can also use the results of other formulas or functions. In particular, you can use the NOW function to generate values on-the-fly. For example, if the current time is 9:42 AM, then HOUR(NOW()) returns 9.

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.