writer
2,661
edits
Changes
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..."
<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 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==
# GETNUMBERTAIL(3.556) = 0.556
# GETNUMBERTAIL([13,-12,90.645]) =
{| class="wikitable"
|+Spreadsheet
|-
|Number
|GETNUMBERTAIL
|-
| 13
| 0
|-
| -12
|
|-
| 90.645
| 0.644999999999996
|}
==Related Videos==
{{#ev:youtube|v=uC09taczvOo|280|center|Column}}
==See Also==
*[[Manuals/calci/GETREALORCOMPLEX | GETREALORCOMPLEX ]]
*[[Manuals/calci/IMREAL | IMREAL]]
where
*<math>Number</math>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==
# GETNUMBERTAIL(3.556) = 0.556
# GETNUMBERTAIL([13,-12,90.645]) =
{| class="wikitable"
|+Spreadsheet
|-
|Number
|GETNUMBERTAIL
|-
| 13
| 0
|-
| -12
|
|-
| 90.645
| 0.644999999999996
|}
==Related Videos==
{{#ev:youtube|v=uC09taczvOo|280|center|Column}}
==See Also==
*[[Manuals/calci/GETREALORCOMPLEX | GETREALORCOMPLEX ]]
*[[Manuals/calci/IMREAL | IMREAL]]