+ Reply to Thread
Results 1 to 5 of 5

a function that referening only to the fracion of the number.

  1. #1
    Registered User
    Join Date
    05-08-2017
    Location
    cyprus
    MS-Off Ver
    office 2010
    Posts
    2

    a function that referening only to the fracion of the number.

    Hey there,
    I request your kind help :
    i am looking for
    a function that referening only to the fracion of the number.
    for example, if i devide a number by 5.5 and the fraction is over 0.8, i would like the function to round up the number.
    If not, Roundown is necessary.
    Is there any relevant function\multiple function that can help me?

    Thank you very much!!

    Smoch

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: a function that referening only to the fracion of the number.

    Welcome to the forum

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Replace the zero with 1 if you want to round up to 1 decimal place etc

    Edit - correction - I misread your post. Also not sure what needs rounding - the original number or the number divided by 5.5. Amend to suit your requirements.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by kev_; 05-08-2017 at 08:29 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: a function that referening only to the fracion of the number.

    OR, you could use the INTEGER function like this:
    Round down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Round up
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Instead of the ROUNDUP and ROUNDOWN elements in previous post

    I assume that your numbers are always > 0
    Last edited by kev_; 05-08-2017 at 08:20 AM.

  4. #4
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: a function that referening only to the fracion of the number.

    =if(trunc(a1/5.5)-a1/5.5>0.8,trunc(a1/5.5)+1,trunc(a1/5.5))

    or

    =IF(INT(A1/5.5)-A1/5.5>0.8,INT(A1/5.5)+1,INT(A1/5.5))

  5. #5
    Registered User
    Join Date
    05-08-2017
    Location
    cyprus
    MS-Off Ver
    office 2010
    Posts
    2

    Re: a function that referening only to the fracion of the number.

    it worked
    thank you very much
    appriciate the help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need a function to give the last row number/cell number
    By kishoremcp in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-20-2013, 04:47 AM
  2. [SOLVED] Condition and function to write number value greater than a specific number
    By excelinexcel7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2012, 06:09 PM
  3. Replies: 13
    Last Post: 03-14-2012, 02:42 PM
  4. Cell input number as row number in function between sheets
    By jblewis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-30-2010, 09:47 AM
  5. Referening cells inside a named range
    By kayard in forum Excel General
    Replies: 3
    Last Post: 06-15-2010, 05:55 AM
  6. [SOLVED] Problems with programatically referening libraries
    By DW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2006, 04:20 AM
  7. Replies: 2
    Last Post: 08-15-2005, 03:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1