/    Sign up×
Community /Pin to ProfileBookmark

Excel help

Copy linkTweet thisAlerts:
Apr 14.2008

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!

to post a comment
Full-stack Developer

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@TheBearMayApr 14.2008 — 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?
Copy linkTweet thisAlerts:
@Crazy_CooterApr 15.2008 — Here's how to do regular rounding:

ORIGINAL # [COLOR="Blue"]FORMULA[/COLOR] [COLOR="Green"]RESULT[/COLOR]

314.15927 [COLOR="Blue"]=ROUNDUP(B3,0)[/COLOR] [COLOR="Green"]315[/COLOR]

314.15927 [COLOR="Blue"]=ROUNDUP(B4,1)[/COLOR] [COLOR="Green"]314.2[/COLOR]

314.15927 [COLOR="Blue"]=ROUNDUP(B5,-1)[/COLOR] [COLOR="Green"]320[/COLOR]

314.15927 [COLOR="Blue"]=ROUNDDOWN(B6,0)[/COLOR] [COLOR="Green"]314[/COLOR]

314.15927 [COLOR="Blue"]=ROUNDDOWN(B7,1)[/COLOR] [COLOR="Green"]314.1[/COLOR]

314.15927 [COLOR="Blue"]=ROUNDDOWN(B8,-1)[/COLOR] [COLOR="Green"]310[/COLOR]

314.15927 [COLOR="Blue"]=ROUND(B9,0)[/COLOR] [COLOR="Green"]314[/COLOR]
Copy linkTweet thisAlerts:
@Crazy_CooterApr 15.2008 — Here's a small screenshot (easier to see what's happening)

[upl-file uuid=73b0dadc-3e5c-4f43-8a3f-9d9c7fcd1cc7 size=7kB]temp_041408.gif[/upl-file]
×

Success!

Help @graphical_force spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.7,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...