|
FN used to mark for footnotes whether a result comment exists for the Varid and the date defined by the offset.
SYNTAX:
FN(Offset, VarNum)
Offset/Date: Sets the number of days from the start date of the report. If the Offset is a date literal string (i.e. "07/16/2004") or refers to a cell with a date in it, it is assumed to be the date to check for a sample comment.
VarNum: The variable Number to look for result comments for. Can be a cell reference to a cell containing a variable number.
NOTES:
Use Locate, Daily Values and check the Footnote Result Comments to locate this formula.
EXAMPLES:
If the start date is 1/1/2000 and the offset is 1, the value from 1/1/2000 will be returned. If the offset is 2, the value from 1/2/2000 will be returned and so forth. Returns "*1" for the first footnote, "*2" for second, etc...
FN(1,1) Returns value from 1/1/2000 for var #1.
FN(2,1) Returns value from 1/2/2000 for var #1.
FN(B4,C3) returns value for date in B4 and variable number in C3.
|