Fractional part of decimals?

[Zerex71]

Greetings,

I thought for sure there was a way to do this but the Excel help does
not tell me. I have number which I would like to take the fractional
part of (if x = 10.48, f(x) = 0.48). Is there a function to do this?

Mike

[Chip Pearson]

Try something like

=A1-INT(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zerex71" <mfeher@stny.rr.com> wrote in message
news:1151526804.724493.58270@p79g2000cwp.googlegroups.com...
> Greetings,
>
> I thought for sure there was a way to do this but the Excel
> help does
> not tell me. I have number which I would like to take the
> fractional
> part of (if x = 10.48, f(x) = 0.48). Is there a function to do
> this?
>
> Mike
>

[Spreadsheet]

f(x)=x-TRUNC(x) should do the trick (insert Cell reference for x).

[Bearacade]

I am not sure if there is a function for it.. but you can use this..

=RIGHT(A1, SEARCH(".",A1))

[Chip Pearson]

A better formula that will work properly with negative numbers
would be

=A1-TRUNC(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Zerex71" <mfeher@stny.rr.com> wrote in message
news:1151526804.724493.58270@p79g2000cwp.googlegroups.com...
> Greetings,
>
> I thought for sure there was a way to do this but the Excel
> help does
> not tell me. I have number which I would like to take the
> fractional
> part of (if x = 10.48, f(x) = 0.48). Is there a function to do
> this?
>
> Mike
>

[Peo Sjoblom]

=MOD(cell,1)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Zerex71" <mfeher@stny.rr.com> wrote in message
news:1151526804.724493.58270@p79g2000cwp.googlegroups.com...
> Greetings,
>
> I thought for sure there was a way to do this but the Excel help does
> not tell me. I have number which I would like to take the fractional
> part of (if x = 10.48, f(x) = 0.48). Is there a function to do this?
>
> Mike
>

[Zerex71]

That did it! Thanks! I totally didn't think to do that. What I am
trying to do is take a number, any number, and cut it down in such a
way as to get it to a decimal between 1.0-2.0, because I have values
for the gamma function between 1.0 and 2.0, though I can count
up/extrapolate using the known formula for subsequent gamma function
values. In other words, since I don't have values for the gamma
function outside of 1.0-2.0, I am recalculating successive gammas, but
I start with a number well outside of 1.0-2.0 range. Make sense? (So
if the desired x for the gamma function is 10.48, I want to cut it down
to start at 1.48; if x = 5.11, I want the number to be 1.11.)

Mike

Spreadsheet wrote:
> f(x)=x-TRUNC(x) should do the trick (insert Cell reference for x).
>
>
> --
> Spreadsheet
> ------------------------------------------------------------------------
> Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
> View this thread: http://www.excelforum.com/showthread...hreadid=556668

[Dana DeLouis]

> .... In other words, since I don't have values for the gamma
> function outside of 1.0-2.0, I am recalculating successive gammas...

Don't know if this will help, so I'll just throw it out...

Function Gamma(x)
Gamma = Exp(WorksheetFunction.GammaLn(x))
End Function

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


"Zerex71" <mfeher@stny.rr.com> wrote in message
news:1151529518.573194.302610@d56g2000cwd.googlegroups.com...
> That did it! Thanks! I totally didn't think to do that. What I am
> trying to do is take a number, any number, and cut it down in such a
> way as to get it to a decimal between 1.0-2.0, because I have values
> for the gamma function between 1.0 and 2.0, though I can count
> up/extrapolate using the known formula for subsequent gamma function
> values. In other words, since I don't have values for the gamma
> function outside of 1.0-2.0, I am recalculating successive gammas, but
> I start with a number well outside of 1.0-2.0 range. Make sense? (So
> if the desired x for the gamma function is 10.48, I want to cut it down
> to start at 1.48; if x = 5.11, I want the number to be 1.11.)
>
> Mike
>
> Spreadsheet wrote:
>> f(x)=x-TRUNC(x) should do the trick (insert Cell reference for x).
>>
>>
>> --
>> Spreadsheet
>> ------------------------------------------------------------------------
>> Spreadsheet's Profile:
>> http://www.excelforum.com/member.php...o&userid=34730
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=556668
>

[Zerex71]

Thanks for the tip. I think I tried something similar, and/or read
about that function in Excel, and it really wasn't going to give me
what I need. Gamma functions are mysterious and as such, I just ended
up using a tabulation of the gamma function for values between 1.0-2.0,
and because there is a way to predict values outside of that range, I
used it to do what I was looking for. I believe it just might have
worked but I'm not certain.

Mike

Dana DeLouis wrote:
> > .... In other words, since I don't have values for the gamma
> > function outside of 1.0-2.0, I am recalculating successive gammas...
>
> Don't know if this will help, so I'll just throw it out...
>
> Function Gamma(x)
> Gamma = Exp(WorksheetFunction.GammaLn(x))
> End Function
>
> --
> HTH. :>)
> Dana DeLouis
> Windows XP, Office 2003
>
>
> "Zerex71" <mfeher@stny.rr.com> wrote in message
> news:1151529518.573194.302610@d56g2000cwd.googlegroups.com...
> > That did it! Thanks! I totally didn't think to do that. What I am
> > trying to do is take a number, any number, and cut it down in such a
> > way as to get it to a decimal between 1.0-2.0, because I have values
> > for the gamma function between 1.0 and 2.0, though I can count
> > up/extrapolate using the known formula for subsequent gamma function
> > values. In other words, since I don't have values for the gamma
> > function outside of 1.0-2.0, I am recalculating successive gammas, but
> > I start with a number well outside of 1.0-2.0 range. Make sense? (So
> > if the desired x for the gamma function is 10.48, I want to cut it down
> > to start at 1.48; if x = 5.11, I want the number to be 1.11.)
> >
> > Mike
> >
> > Spreadsheet wrote:
> >> f(x)=x-TRUNC(x) should do the trick (insert Cell reference for x).
> >>
> >>
> >> --
> >> Spreadsheet
> >> ------------------------------------------------------------------------
> >> Spreadsheet's Profile:
> >> http://www.excelforum.com/member.php...o&userid=34730
> >> View this thread:
> >> http://www.excelforum.com/showthread...hreadid=556668
> >

[Titus]

try this,
=IF(INT(cell>1),1+(MOD(cell,1)),MOD(cell,10))