Replies

1. 
   jimAKAblue | Aug 02, 2009 09:05pm | #1

   Oh...I forgot to mention...I don't mind help from non geniuses either LOL.

2. 
   Ken | Aug 02, 2009 09:45pm | #2

   Use =roundup (cell, 0)   ROUNDUP

   View ImageShow All Hide All Rounds a number up, away from 0 (zero). Syntax ROUNDUP(number,num_digits) Number   is any real number that you want rounded up. Num_digits   is the number of digits to which you want to round number. Remarks ROUNDUP behaves like ROUND, except that it always rounds a number up. If num_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places. If num_digits is 0, then number is rounded up to the nearest integer. If num_digits is less than 0, then number is rounded up to the left of the decimal point. Example The example may be easier to understand if you copy it to a blank worksheet. View ImageHow to copy an example Create a blank workbook or worksheet. Select the example in the Help topic. Note  Do not select the row or column headers. View Image Selecting an example from Help Press CTRL+C. In the worksheet, select cell A1, and press CTRL+V. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.   1 2 3 4 5 6 A B Formula Description (Result) =ROUNDUP(3.2,0) Rounds 3.2 up to zero decimal places (4) =ROUNDUP(76.9,0) Rounds 76.9 up to zero decimal places (77) =ROUNDUP(3.14159, 3) Rounds 3.14159 up to three decimal places (3.142) =ROUNDUP(-3.14159, 1) Rounds -3.14159 up to one decimal place (-3.2) =ROUNDUP(31415.92654, -2) Rounds 31415.92654 up to 2 decimal places to the left of the decimal (31500)
1. 
   Ken | Aug 02, 2009 09:47pm | #3

   Hope the formatting shows up better on your screen than mine.

   Anyway, cut and paste from the help file:

   =Roundup (cell rounding up i.e. D1, 0)

   The zero rounds up to whole numbers.

2. 
   jimAKAblue | Aug 03, 2009 03:40am | #9

   Thanks Ken.

   I couldn't make any sense out of the formatting that you posted but when I searched the help file and typed in roundup, it led me to the answer.

   I got it working after a half a dozen attempts. I don't understand why, but I have to type =roundup and then (a4,0). I understand the a4 part of the equation but I don't know why I have to put the comma and then a zero. I don't really need to know but I have an easier time remembering if I know the "whys".

1. 
   Ozlander | Aug 03, 2009 04:00am | #11

   The ,0 is the number of decimal places you want. 0 is none.

1. 
   jimAKAblue | Aug 03, 2009 04:23am | #13

   aha! That makes sense. Thanks.

   Now...I have another question.

   When we order shingles, we order by the square in units of 1/3. I'd love to be able to make the program roundup 35.44 to say "35 1/3". Is that possible?

1. 
   Ozlander | Aug 03, 2009 04:37am | #14

   Well, first of all 0.44 will not round UP to 1/3.

   Other than that, I don't know of an easy way.

2. 
   elicon | Aug 03, 2009 05:02am | #17

   Jim,Yes, it can be done, and the basic formula is:=ROUNDUP(A1*A2/100*3,0)/3The A1 and A2 are the length and width of the roof, and both of the 3's are for 3 bundles per square. If you're using shingles that takes 4 bundles to make a square, use 4's in place of the 3's. By the way, you should buy "Estimating with Microsoft Excel" by Jay Christofferson. This book will show how to really harness the power of Excel for estimating. Hope this helps.

3. 
   jimAKAblue | Aug 03, 2009 05:28am | #20

   Thanks elicon. Toolfreak beat you to it but only by a few seconds. I will track down that book because I'm liking the power of this program. I started learning it last year and I'm getting a bit serious about it.

4. 
   jimAKAblue | Aug 03, 2009 05:23am | #18

   LOL Duh!

5. 
   ToolFreakBlue | Aug 03, 2009 04:48am | #15

   I assume you meant 35 2/3, right?Best I can figure requires two cells, can't seem to get them the work togetherA1______________B1________________C1
   35.44_______=ROUNDUP(A1*3,0)___=+B1/3C1 returns 35.66 but formatted for Numbers, fractions, Upto 1 dig1t will display 35 2/3TFB (Bill)Edited to get the cell numbers alligned with the "cells"

   Edited 8/2/2009 9:51 pm by ToolFreakBlue

6. 
   ToolFreakBlue | Aug 03, 2009 05:01am | #16

   Got it=ROUNDUP(A1*3,0)/3 where A1 is your original calculated value.Format the cell for Number/ Fractions/ Upto 1 digitTFB (Bill)

7. 
   jimAKAblue | Aug 03, 2009 05:27am | #19

   That worked!

   The thing that confused me was that when I peaked into the fractions formatting box, it showed 1/4. I didn't realize that it would automatically input 1/3 if I was closer to thirds. I thought it would only do quarters.

   Thanks a bunch. To me, you are a genius!

3. 
   gfretwell | Aug 02, 2009 10:47pm | #4

   Why did Microsoft.com try to set a cookie when I opened this topic?
   Is Bill Gates really watching us all the time?

1. 
   IMERC | Aug 02, 2009 11:18pm | #5

   and then some... 

   Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming<!----><!----><!---->

   WOW!!! What a Ride!

   Forget the primal scream, just ROAR!!!

    

   "Some days it's just not worth chewing through the restraints"

2. 
   peteshlagor | Aug 03, 2009 01:11am | #6

   He don't like the color of your shorts.

    

1. 
   brownbagg | Aug 03, 2009 02:26am | #7

   who wearing shorts?

1. 
   peteshlagor | Aug 03, 2009 03:38am | #8

   That's a horrible mental image.

   No wonder you need that 10' wall about your place.

    

    

1. 
   brownbagg | Aug 03, 2009 03:59am | #10

   basiclly, yes

2. 
   gfretwell | Aug 03, 2009 04:07am | #12

   Of course I am wearing shorts, I live in SW Florida ... but no panties if that was your question.