Difference between revisions of "Manuals/calci/GETNUMBERTAIL"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''GETNUMBERTAIL(Number)'''</div><br/> where *<math>Number</math>is a single number or set of values. ==Description== *This function gives the de...") |
|||
| (4 intermediate revisions 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 23: | Line 23: | ||
|- | |- | ||
| -12 | | -12 | ||
| − | | | + | | 0 |
|- | |- | ||
| 90.645 | | 90.645 | ||
| 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