How to round float to bigger integer?

Question

In Google Sheet, we can use ROUND() to round float to the nearest. like

5.2 = 5
5.5 = 6.

What if I want it:

5.2 = 6
5.5 = 6.

If the number exceeds by a decimal, then rounded off to +1. Any idea?

Rubén · Accepted Answer · 2019-01-18 05:19:35Z

1

Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

answered Jan 18 '19 at 5:19

Rubén♦

38.6k14 gold badges75 silver badges240 bronze badges

Add a comment |

user0 · Accepted Answer · 2019-01-18 05:49:59Z

1

=ROUNDUP(A2; 0)

=ARRAYFORMULA(IF(LEN(A1:A); ROUNDUP(A1:A; 0); ))

answered Jan 18 '19 at 5:49

user0

22.8k8 gold badges38 silver badges64 bronze badges

Add a comment |

2 Answers 2