How to round an integer up (Excel)?

L

LebedevStr2020-08-07 00:59:36

excel

LebedevStr, 2020-08-07 00:59:36

Hello. What is the formula for rounding an integer up?
It was 744, now it's 750.

Thank you.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

G

Grigory Boev, 2020-08-07
@LebedevStr

Up to ten
=ОКРУГЛВВЕРХ(A1/10;0)*10
Up to even
=ОКРУГЛВВЕРХ(A1/2;0)*2
Up to fives
=ОКРУГЛВВЕРХ(A1/5;0)*5
, etc.

L

LebedevStr, 2020-08-07
@LebedevStr

helped

=A2+(OSTAT(A2;10)>0)*(10-OSTAT(A2;10))

Similar questions

D

Denis Mashanov2016-12-01 21:22:56

C

chief2016-12-12 11:57:50

M

Mikhail Mikhail2021-01-15 16:54:40

I

igor9alive2016-12-20 10:58:10

T

timofy2019-05-18 01:17:50

Didn't find what you were looking for?