Take the fraction part out of the number

[0-0 Wai Wai ^-^]

Hi.
I would like to extract the fraction part out of a number. For example:
1.5 -> 0.5
23.45 -> 0.45
25 -> 0

Is there any simple way to do it?
Thank you.


--
Additional information:
- I'm using Office XP
- I'm using Windows XP

¥»¤Hªº¯à¤O«D±`¦³­­. ¦p¦³¤£·í¤§³B, ±æÃѪ̤£§[½ç¥¿!!
After all, the above are merely my little opinion/idea.
Since my ability is limited, I could be wrong.

 

[Niek Otten]

=MOD(A1,1)

--
Kind regards,

Niek Otten

|
|
| Hi.
| I would like to extract the fraction part out of a number. For example:
| 1.5 -> 0.5
| 23.45 -> 0.45
| 25 -> 0
|
| Is there any simple way to do it?
| Thank you.
|
|
| --
| Additional information:
| - I'm using Office XP
| - I'm using Windows XP
|
| ¥»¤Hªº¯à¤O«D±`¦³­­. ¦p¦³¤£·í¤§³B, ±æÃѪ̤£§[½ç¥¿!!
| After all, the above are merely my little opinion/idea.
| Since my ability is limited, I could be wrong.
|
|

 

[Opinicus]

I was going to suggest:

=A1-INT(A1)

but

=MOD(A1,1)

That is a very clever trick!

 

[Michael Bednarek]

=MOD(A1,1)

While this works in the Microsoft Excel worksheet function MOD for
positive values, I believe it contravenes the convention where MOD is
only defined for integer numbers. Many languages, including Microsoft's
VBA, will return 0 for any MOD(x,1).

But even Excel's function MOD(x,1) will return unexpected values for
negative numbers, as will Opinicus's solution of A1-INT(A1). Try this
instead: A1-TRUNC(A1), or -if you don't want to preserve the sign-
ABS(A1-TRUNC(A1).

Note that the Excel worksheet function MOD and the VBA operator Mod
deliver different results for negative values.

Modulo and remainder are not the same thing.

 

[Ragdyer]

Care to comment on:

=MOD(A1,SIGN(A1))

 

[L. Howard Kittle]

And here's my shot at it.

=--RIGHT(A1,FIND(".",A1))

HTH
Regards,
Howard

 

[Flintstone]

This works just as well.

=MID(A1,FIND(".",A1),10)*1

 

[sswilcox]

Frankly, I'm surprised nobody offered this solution which also works
for both positive and negative numbers:

=A1-ROUNDDOWN(A1,0)

Your collective ingenuity continues to amaze me.