roundup before multiplied formula??

[micfly]

I'm sure this is easy for somebody..
How do I multiply two numbers rounded up to the next whole number...


=(A1*B1)

Cell values: 20.5 x 30.25 = 620.125 ...not like this<not like="" this<not="" this="" (="A1*B1)=" 620.125


but lke this... 20.5 x 30.25 (21 x 31) = 651

651 is the answer I'm looking for.</not>

 

[jtakw]

Hi,

Use ROUNDUP like this:

Book1
	A	B	C
1	20.5	30.25	651
Sheet630

Cell Formulas
Range	Formula
C1	=ROUNDUP(A1,0)*ROUNDUP(B1,0)

 

[Michael M]

Maybe this

Excel 2007
	A	B	C
1	20.5	30.25	651
Sheet2

Cell Formulas
Range	Formula
C1	=ROUNDUP(A1,0)*ROUNDUP(B1,0)

 

[micfly]

Okay, I knew you guys would make it look easy But now if I take that formula and put =(C1/144) in D1 I get 651/144= 4.52 - I want 5 to be the answer (D1 rounded up).

 

[jtakw]

Try:

Book1
	A	B	C	D
1	20.5	30.25	651	5
Sheet630

Cell Formulas
Range	Formula
C1	=ROUNDUP(A1,0)*ROUNDUP(B1,0)
D1	=ROUNDUP(C1/144,0)

Edit: BTW, you keep surrounding your Multiplication and Division with Brackets, they're not needed, doesn't hurt, but not needed.

 

[Michael M]

or, if you wanted to save a step.....

Excel 2007
	A	B	C
1	20.5	30.25	5
Sheet1

Cell Formulas
Range	Formula
C1	=ROUNDUP(ROUNDUP(A1,0)*ROUNDUP(B1,0)/144,0)

 

[micfly]

Got it - okay guys you've been a great help!