Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Microsoft Excel, I have a calculus result; for example 8,74.

How can I say to Excel to show me just the fractional part 0,74?

share|improve this question

2 Answers 2

Formula TRUNC(a1) will show the whole part of cell A1, so to get the fractional part, use A1-TRUNC(a1)

Just beware that for negative numbers, like -2.3, this will give you -0.3, not 0.3. To take care of that case, try using ABS(a1-TRUNC(a1)).

share|improve this answer

You can use MOD function with a divisor of 1, e.g. with 8,74 in A1

=MOD(A1;1)

I'm assuming that your region requires semi-colon ; as a separator

share|improve this answer
    
+1 But there seems to be problem with negative numbers though. =MOD(-8.74, 1) returns 0.26. Changing the 2nd argument to -1 (at least when dealing with negative values) should be able to fix it. –  Ellesa Mar 18 '13 at 22:38
    
Since the context is calculus the sign may be relevant so to cover positives and negatives perhaps =IF(A1>0;MOD(A1;1);MOD(A1;1)-1)? –  pnuts Mar 21 '13 at 21:10
1  
I think you could also use =MOD(A1;SIGN(A1)) –  barry houdini Mar 21 '13 at 21:53
    
That comment is worth +1 in itself! –  pnuts Apr 3 '13 at 0:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.