Difference between revisions of "Manuals/calci/GETNUMBERTAIL"

From ZCubes Wiki
Jump to navigation Jump to search
Line 11: Line 11:
 
==Examples==
 
==Examples==
 
# GETNUMBERTAIL(3.556) = 0.556
 
# GETNUMBERTAIL(3.556) = 0.556
 
 
# GETNUMBERTAIL([13,-12,90.645]) =  
 
# GETNUMBERTAIL([13,-12,90.645]) =  
 
{| class="wikitable"
 
{| class="wikitable"
Line 28: Line 27:
 
| 0.644999999999996
 
| 0.644999999999996
 
|}
 
|}
 +
 +
# GETNUMBERTAIL(67ABC112) = 0AB112
  
 
==Related Videos==
 
==Related Videos==

Revision as of 06:40, 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]) =
Spreadsheet
Number GETNUMBERTAIL
13 0
-12 0
90.645 0.644999999999996
  1. GETNUMBERTAIL(67ABC112) = 0AB112

Related Videos

Column

See Also