Manuals/calci/GETNUMBERTAIL

From ZCubes Wiki
Revision as of 05:44, 8 July 2020 by Swapna (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
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

3. GETNUMBERTAIL(67ABC112) = 0ABC112

Related Videos

Column

See Also