Home : NFNP
Q14587 - INFO: NFNP
 NFNP (Not Fixed Numeric Portion) spread function returns the numeric portion of a value with or without a qualifier and does no formatting to the number.  Used to return the numeric portion of a result formatted as Not Fixed as text (string).

SYNTAX:

NFNP(Value/String)

Value/String: A quoted string, cell reference or spread function that returns text (i.e. VT function)

EXAMPLES:

NFNP("<2") - Returns 2

NFNP("14.3") - Returns 14.3

NFNP(A4) - Returns 0.21477 where cell A4 contains "e0.21477".

Qualifier(VT(4011,1,9999)) - Returns the numeric portion of the value returned by the VT function.

SEE ALSO: Qualifier, VAL

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 4/30/2020 8:33 AM.
Last Modified on 4/30/2020 8:33 AM.
Last Modified by Scott Dorner.
Article has been viewed 227 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article