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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get a number to round up in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/191308-how-do-i-get-number-round-up-excel.html)

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

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

Brad

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

=roundup(b1*.1,0)
--
Wag more, bark less

"bb" wrote:

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

Mike H

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

Maybe

=CEILING(B1*0.1,1)

Mike

"bb" wrote:

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

All times are GMT +1. The time now is 05:40 AM.