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!
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
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
Here's a small screenshot (easier to see what's happening)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)