Functions

From Wiki for The Only Sheet

Revision as of 22:06, 11 July 2012 by Admin (talk | contribs) (Created page with "Ordinal(n): Given an integer, returns a string with that number, and the ordinal of that number. *Parameter: n As Integer *Example: =Ordinal(3) *Returns: 3rd =ExtractElement(str...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Ordinal(n): Given an integer, returns a string with that number, and the ordinal of that number.

Parameter: n As Integer
Example: =Ordinal(3)
Returns: 3rd

=ExtractElement(str,n,sep)

Parameter: str as String, n As Integer, sep as String
Example: =ExtractElement("Monkey&Apes&Chimps",2,"&")
Returns: Apes

Retrieved from "https://theonlysheet.com:443/wiki/index.php?title=Functions&oldid=2820"