Sounds to me like you need to check two separate but related functions in
Excel.

If x= 127.6543

INT(x) = 127 INT returns just the integer part of a number

Also,

if x = 127.6543

MOD(x, INT(x)) = .6543 MOD() returns the fraction after the decimal
remaining after dividing by the second argument, in this case INT(x). Note
that I've used INT to return the whole integer part and used it as the
divisor.

This should be a reliable mathematical method, but I would bet there's also
a reliable text function method to do this.

Hope that helps.

"ratedr1@aol.com" wrote:

> OK I know this might sound like a strange question. But I am trying to
> write a formula for a machine that I have in my factory. It is a multi
> step formula, and in one of the steps it will give a result, for
> example, of 127.6543. Is there ANY possible way for me to ask the
> next part of the formula to ONLY use the .6543 without taking the 127
> into account, or without having to tell it to subtract the 127 manually
> (and ALSO vice versa meaning I need it to then use ONLY the 127 and NOT
> the .6543) ?? I hope I am making myself clear, because Im not even
> sure that I understand what I am asking now that I look at it, but
> since I am not versed in excel, I am hoping some intelligent soul will
> understand my query.
>
> Thanks in advance,
> Scott
>
>