Home : Qualifier
Q11282 - INFO: Qualifier

Qualifier returns the symbol/data qualifier for the specified value

SYNTAX:

Qualifier(Value/String, Optional NoQualifierPrint)

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

NoQualifierPrint: A quoted string of what to print if no qualifier exists.  If not specified function returns "" if no qualifier.

EXAMPLES:

Qualifier("<2") - Returns <

Qualifier("14.3") - Returns no result (i.e. "")

Qualifier("14.3","=") - Returns = as there is no qualifier so the NoQualifierPrint of = is returned.

Qualifier(A4) - Returns e where cell A4 contains "e0.2".

Qualifier(VT(4011,1)) - Returns the symbol for the value returned by the VT function.

SEE ALSO: NFNP, 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 6/2/2008 11:43 AM.
Last Modified on 2/17/2021 12:12 PM.
Last Modified by Scott Dorner.
Article has been viewed 3192 times.
Rated 2 out of 10 based on 1 vote.
Print Article
Email Article