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