# roundup before multiplied formula??

#### micfly

##### Well-known Member
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>

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

#### jtakw

##### Well-known Member
Hi,

Use ROUNDUP like this:

Maybe this

Last edited:

#### micfly

##### Well-known Member
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

##### Well-known Member

Try:

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

Last edited:

#### Michael M

##### Well-known Member
or, if you wanted to save a step.....

Last edited:

#### micfly

##### Well-known Member
Got it - okay guys you've been a great help!

Replies
0
Views
21
Replies
8
Views
244
Replies
3
Views
285
Replies
5
Views
94
Replies
2
Views
81