Release List Reviews Shop Join News DVD Giveaways Video Games Advertise
DVD Reviews | Theatrical Reviews | Price Search Buy Stuff Here
DVD Talk
DVD Reviews DVD Talk Headlines HD Reviews

Add to My Yahoo! - RSS 2.0 - RSS 2.0 - DVD Talk Podcast RSS -

Go Back   DVD Talk Forum > General Discussions > Tech Talk

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Thread Tools
Old 05-25-08, 08:25 PM   #1
DVD Talk Platinum Edition
Join Date: May 2001
Location: In my Home Theater- Foley, AL
Posts: 3,502
Excel Question: Rounding up

I am trying to get B11 to round up and read 0.67. Can someone help me figure out how to do this?

What do I add to this: =B6/12 to make it round up to 0.67?

Thanks for any help!

Last edited by Sonicflood; 05-27-08 at 08:44 PM.
  Reply With Quote
Old 05-25-08, 08:31 PM   #2
DVD Talk Hall of Fame
Join Date: Aug 2002
Location: Triangle, NC, USA
Posts: 8,446
format cells, Number, two decimal places?
I have nothing to say.
My dvds
360 Gamertag: tonyc3742
  Reply With Quote
Old 05-26-08, 03:27 PM   #3
New Member
Join Date: Jun 2007
Posts: 17
In the formula for B11 type, "=round(B6/12,2)".
  Reply With Quote
Old 05-27-08, 03:25 PM   #4
DVD Talk Legend
kenbuzz's Avatar
Join Date: Jun 2000
Location: Bloomington, IN
Posts: 19,854
Originally Posted by nicnic
In the formula for B11 type, "=round(B6/12,2)".
Yup, that's the right answer if he's looking to round B6/12 to the nearest .01. If he wants to round it UP, the function he should use is roundup(). If he wants it to the next higher .01, B11 should be "=roundup(b6/12,2)". If the next higher integer, "=roundup(b6/12,0)".

roundup() and trunc() allow you to get the next higher (and lower) value without necessarily rounding to the "nearest" value.
Sweed goes down with an achillies injury. As a Steelers fan, this is great news. - Tarantino, 5-02-10
If Tebow beats the Steelers today, I will post a pic of me Tebow'ing in one of my Pittsburgh jerseys. - Tarantino, 1-08-12
I am glad you've allowed the medical community to try and fix your laziness - aktick, 4-20-16
  Reply With Quote
Old 05-27-08, 08:44 PM   #5
DVD Talk Platinum Edition
Join Date: May 2001
Location: In my Home Theater- Foley, AL
Posts: 3,502
Thanks for the replies. It's working properly now.
  Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -5. The time now is 03:18 PM.

Copyright 2011 All Rights Reserved. Privacy Policy and Terms of Use.

Content Relevant URLs by vBSEO 3.2.0