Results 1 to 3 of 3

Thread: Rounddown problem

  1. #1

    Rounddown problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello again. I have this worksheet. Where is red should be 5.0 but there's nothing (0.0). I think formula's a good one...if i'm wrong, correct me.

    Thanks
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    That is caused by Excel Floating Point arithmetic which may cause inaccurate results... see https://support.microsoft.com/en-us/kb/78113

    Try Rounding the result of the inner function to one decimal to match your table entries)

    =ROUNDDOWN(ROUND((SUM($H19:AK19)+$E19-SUM($H20:AJ20)),1)/$B20,0)*$B20


  3. #3
    Quote Originally Posted by NBVC View Post
    That is caused by Excel Floating Point arithmetic which may cause inaccurate results... see https://support.microsoft.com/en-us/kb/78113

    Try Rounding the result of the inner function to one decimal to match your table entries)

    =ROUNDDOWN(ROUND((SUM($H19:AK19)+$E19-SUM($H20:AJ20)),1)/$B20,0)*$B20

    Thanks, It work perfect!!!

Posting Permissions

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