Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Posts
    88
    Provided Answers: 1

    Answered: Math Format Needed

    Hello Guys....

    im trying to get a math format for a mathematical field. This is how i want the behaviour...

    i want all decimals to approximated to the next whole number... eg. 1.01 should be approximated to 2

    so after a whole number if there be any decimal it should be approximated to the next whole number

    other examples also are;

    1.56 should be approximated to 2
    3.14 should be approximated to 4 and so on....

    Thanks for you help earlier....

    Regards
    Evans

  2. Best Answer
    Posted by Java7

    "Hello James.... thanks alot for your response....

    i took your file and modified the scripts to suit the idea kinda... i didnt write variables tho..
    you can see from the attached file

    Regards
    Evans

    Attachment 16520"


  3. #2
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Not so simple because figures don't round off like that at all in Maths traditionally.
    You have to use a variable in order to achieve this. See attached for a working example.

    Regards
    James.
    Attached Files Attached Files

  4. #3
    Join Date
    Oct 2014
    Posts
    88
    Provided Answers: 1
    Hello James.... thanks alot for your response....

    i took your file and modified the scripts to suit the idea kinda... i didnt write variables tho..
    you can see from the attached file

    Regards
    Evans

    round.zip

Posting Permissions

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