Difference between revisions of "Manuals/calci/GETNUMBERTAIL"
(One intermediate revision by the same user not shown) | |||
Line 10: | Line 10: | ||
==Examples== | ==Examples== | ||
− | + | 1. GETNUMBERTAIL(3.556) = 0.556 | |
− | + | ||
+ | 2. GETNUMBERTAIL([13,-12,90.645]) = | ||
{| class="wikitable" | {| class="wikitable" | ||
|+Spreadsheet | |+Spreadsheet | ||
Line 27: | Line 28: | ||
| 0.644999999999996 | | 0.644999999999996 | ||
|} | |} | ||
− | + | 3. GETNUMBERTAIL(67ABC112) = 0ABC112 | |
− | |||
==Related Videos== | ==Related Videos== |
Latest revision as of 06:44, 8 July 2020
GETNUMBERTAIL(Number)
where
- is a single number or set of values.
Description
- This function gives the decimal part of each number from the given set of values.
- If the given number is an interger, '0' is displayed as a result.
- For any non-numeric values, function gives an error message.
Examples
1. GETNUMBERTAIL(3.556) = 0.556
2. GETNUMBERTAIL([13,-12,90.645]) =
Number | GETNUMBERTAIL |
13 | 0 |
-12 | 0 |
90.645 | 0.644999999999996 |
3. GETNUMBERTAIL(67ABC112) = 0ABC112