Excel Question: Rounding up

Sonicflood · 05-25-08, 08:25 PM

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!

dtcarson · 05-25-08, 08:31 PM

format cells, Number, two decimal places?

nicnic · 05-26-08, 03:27 PM

In the formula for B11 type, "=round(B6/12,2)".

kenbuzz · 05-27-08, 03:25 PM

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.

Sonicflood · 05-27-08, 08:44 PM

Thanks for the replies. It's working properly now.

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,496	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.

05-25-08, 08:31 PM	#2
dtcarson DVD Talk Hall of Fame Join Date: Aug 2002 Location: Triangle, NC, USA Posts: 8,082	format cells, Number, two decimal places? __________________ I have nothing to say. My dvds 360 Gamertag: dtcarson

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,496	Thanks for the replies. It's working properly now. __________________

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)".