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))