Jim Sweet wrote:
> 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
> >
> >