Release List Reviews Shop Join News DVD Giveaways Video Games Advertise
DVD Reviews | Theatrical Reviews | Adult DVD Reviews | Video Game 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

Reply
 
Thread Tools
Old 05-25-08, 08:25 PM   #1
Sonicflood
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
dtcarson
DVD Talk Hall of Fame
 
Join Date: Aug 2002
Location: Triangle, NC, USA
Posts: 8,229
format cells, Number, two decimal places?
__________________
I have nothing to say.
My dvds
360 Gamertag: dtcarson
  Reply With Quote
Old 05-26-08, 03:27 PM   #3
nicnic
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
kenbuzz
DVD Talk Legend
 
kenbuzz's Avatar
 
Join Date: Jun 2000
Location: Bloomington, IN "Who Dey!"
Posts: 16,224
Quote:
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.
__________________
(Twitter) Janay Rice says she deeply regrets the role she played the night of the incident. - Baltimore Ravens, 5-23-14
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
  Reply With Quote
Old 05-27-08, 08:44 PM   #5
Sonicflood
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
Reply

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 10:46 AM.

Rules - DVD Talk - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Copyright 2011 DVDTalk.com All Rights Reserved. Privacy Policy and Terms of Use.