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 05:44, 8 July 2020
GETNUMBERTAIL(Number)
where
- is a single number or set of values.
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