Home : FN
Q11269 - INFO: FN

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. 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/21/2008 7:32 PM.
Last Modified on 8/31/2016 9:52 AM.
Last Modified by Scott Dorner.
Article has been viewed 1713 times.
Rated 6 out of 10 based on 2 votes.
Print Article
Email Article