Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Rounding Number In Formula To Remove Decimal

  1. #1
    Join Date
    9th September 2006
    Posts
    136

    Rounding Number In Formula To Remove Decimal

    My formula is not rounding properly. Cells I4, J4 and K4 all filter from the results of cell I3 divided by 3. (e.g. 10/3 = 3.333) I was able to remove the decimals in cells I1:K3, but the between formulas (I4:K4) keeps adding the decimal back, therefore this results in errors to my chart.

    Any suggestions to correct this???
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    11th March 2005
    Location
    Los Angeles
    Posts
    500

    Re: Rounding Number In Formula To Remove Decimal

    you can always add
    VB:
    =int(your code + 0.5) 
    
    
    Eternity is a terrible thought. I mean, where's it going to end??

  3. #3
    Join Date
    9th September 2006
    Posts
    136

    Re: Rounding Number In Formula To Remove Decimal

    Thanks, Fengore

    I found the solution to the problem after making another post, I saw someone else had a similar question.

    The answer was for me to round down.

    =ROUNDDOWN((I3/3),0)

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    9th September 2006
    Posts
    136

    Re: Rounding Number In Formula To Remove Decimal

    Thanks, Fengore

    I found the solution to the problem after making another post, I saw someone else had a similar question.

    The answer was for me to round down.

    =ROUNDDOWN((I3/3),0)

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    11th March 2005
    Location
    Los Angeles
    Posts
    500

    Re: Rounding Number In Formula To Remove Decimal

    That works too.
    Eternity is a terrible thought. I mean, where's it going to end??

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Rounding Decimal Places In Vba
    By cellulargiant in forum EXCEL HELP
    Replies: 5
    Last Post: March 19th, 2007, 14:31
  2. Decimal Place Rounding Error
    By Reafidy in forum EXCEL HELP
    Replies: 11
    Last Post: February 20th, 2007, 03:19
  3. Decimal - Very controlled rounding
    By JudyHNM in forum EXCEL HELP
    Replies: 1
    Last Post: July 24th, 2005, 08:40
  4. rounding to the nearst 100th decimal
    By bobaymon in forum EXCEL HELP
    Replies: 2
    Last Post: January 18th, 2005, 05:02
  5. rounding numbers based on .001 decimal
    By dgates12 in forum EXCEL HELP
    Replies: 10
    Last Post: December 21st, 2004, 21:42

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
  •  
porno