Difference between revisions of "Manuals/calci/SPELLNUMBER"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''SPELLNUMBER (OriginalNumber,MajorUnitPlural,MinorUnitPlural,MajorUnitSingular,MinorUnitSingular,NumberOfDecimals) '''</div><br/> *<math>Original...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size: | + | <div style="font-size:20px">'''SPELLNUMBER (OriginalNumber,MajorUnitPlural,MinorUnitPlural,MajorUnitSingular,MinorUnitSingular,NumberOfDecimals) '''</div><br/> |
*<math>OriginalNumber</math> is any value. | *<math>OriginalNumber</math> is any value. | ||
| Line 14: | Line 14: | ||
# SPELLNUMBER(87,3) = Eighty Seven 3 And Zero Cents | # SPELLNUMBER(87,3) = Eighty Seven 3 And Zero Cents | ||
# SPELLNUMBER(87,3,1) = Eighty Seven 3 And Zero 1 | # SPELLNUMBER(87,3,1) = Eighty Seven 3 And Zero 1 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=e0dJWfQHF8Y|280|center|Numbers}} | ||
==See Also== | ==See Also== | ||
*[[Manuals/calci/SPELLINTEGER| SPELLINTEGER]] | *[[Manuals/calci/SPELLINTEGER| SPELLINTEGER]] | ||
| − | + | *[[Manuals/calci/SPELLTENS | SPELLTENS]] | |
| − | *[[Manuals/calci/ | ||
| − | |||
*[[Manuals/calci/SPELLTEENS | SPELLTEENS]] | *[[Manuals/calci/SPELLTEENS | SPELLTEENS]] | ||
| − | |||
==References== | ==References== | ||
Latest revision as of 13:04, 4 April 2019
SPELLNUMBER (OriginalNumber,MajorUnitPlural,MinorUnitPlural,MajorUnitSingular,MinorUnitSingular,NumberOfDecimals)
- is any value.
is any value.
Description
- This function shows the spelling or number name of the given number.
- Argument number can be any whole number or decimal number.
- The whole number will consider as dollar and the decimals will consider as cents.
- For non-numeric argument such as character,string or special characters,will display as non numeric dollar and non numeric cents.
Examples
- SPELLNUMBER(87) = Eighty Seven Dollars And Zero Cents
- SPELLNUMBER(87,3) = Eighty Seven 3 And Zero Cents
- SPELLNUMBER(87,3,1) = Eighty Seven 3 And Zero 1
Related Videos
See Also
References