Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    178

    Unanswered: opposite of Truncate command in excel

    Hi guys,

    Is there an opposite of Trunc command in Excel?

    i.e

    If i Trunc(1.2222)

    I get "1"


    But i just want the "2222"

    any ideas?

    thanks

    aboo

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi aboo

    How about =Mod(1.222,1) ??

    or what MOD it is derived from 1.22-1*Int(1.222/1)

    or, in this case, just 1.222-Int(1.222)

    If you have negative numbers this will need considering?

    It's all in excel help.

    MTB

  3. #3
    Join Date
    May 2006
    Posts
    178
    thanks Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •