www.webdeveloper.com
Results 1 to 4 of 4

Thread: Excel help

Hybrid View

  1. #1
    Join Date
    Nov 2007
    Location
    Parts Unknown......
    Posts
    88

    Excel help

    Hi, I am not sure where to post this thread at so I thought I would try here. I am helping someone out and they need a solution that would change a column of data by rounding it to a certain amount based on what the original value is. They are using office 2003 Excel and I have 2007 and open office. I know you can write functions to do some of the stuff but I am a excel noobie.

    Does anyone have any suggestions on how I should handle this or is there some great pre-written functions already out there that I can get access to?

    Thanks in advance!

  2. #2
    Join Date
    Nov 2003
    Location
    Worthington, OH, USA
    Posts
    3,634
    Going to need a little more detail (at least I do), on what the specifics are on this rounding. If this isn't "regular" rounding what are the parameters?
    54 68 65 42 65 61 72 4D 61 79

  3. #3
    Join Date
    Apr 2008
    Posts
    5
    Here's how to do regular rounding:
    ORIGINAL # FORMULA RESULT
    314.15927 =ROUNDUP(B3,0) 315
    314.15927 =ROUNDUP(B4,1) 314.2
    314.15927 =ROUNDUP(B5,-1) 320
    314.15927 =ROUNDDOWN(B6,0) 314
    314.15927 =ROUNDDOWN(B7,1) 314.1
    314.15927 =ROUNDDOWN(B8,-1) 310
    314.15927 =ROUND(B9,0) 314

  4. #4
    Join Date
    Apr 2008
    Posts
    5
    Here's a small screenshot (easier to see what's happening)
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Posting Permissions

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



Recent Articles