How do I get a number to round up in excel?

bb · Jun 15, 2008

I need to round up 1.4 to 2. But I'm already using a formula in that cell
=(B1*.1)?

Brad · Jun 15, 2008

=roundup(b1*.1,0)

Mike H · Jun 15, 2008

Maybe

=CEILING(B1*0.1,1)

Mike