Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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. – Kaze 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .