Home : VNFF
Q14563 - INFO: VNFF

VNFF returns the Variable Number From a Formula.

SYNTAX:

VNFF(Cell Ref)

Cell Ref: A cell reference (A1, B2...) that contains a formula that refers to a variable (i.e. V, GAVG, DDVT,...)

EXAMPLES:

VNFF(B6) returns 41 where cell B6 has the formula V(41,1)

VNFF(C4) returns 11 where cell C6 has the formula VINFO(11,"NAME")

VNFF(D37) returns 4011 where cell D37 has the formula GAVG(D2,1,"M") and cell D2 = 4011.

SEE ALSO: VARNUM

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 1/7/2020 4:54 PM.
Last Modified on 1/7/2020 4:54 PM.
Last Modified by Scott Dorner.
Article has been viewed 144 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article