Function that returns decimals only
Rexburgh,
The MOD function returns the remainder from a division, you can get
the decimal portion of a number by dividing by 1... if your value was
in A1:
=MOD(A1,1)
Dan E
"rexburgh" wrote in message ...
Can someone help?
I need to know if there exists an excel function for use to return decimals
only in any given numer.
Example:
1241,17 to be displayed/returned as 17
18,875 to be displayed/returned as 875 etc.
Thanks for any help on this issue.
|