CODEWITHSUNDEEP
excelexcel-formula
asokan
asokan

Reputation: 199

excel formula to round off value on the higher side

excel formula to round off value on the higher side 

=ROUND(A1,0)

isn't working the way I want

Desired output

38.18 --> 39
26.22 --> 27

Upvotes: 0

Views: 1202

Answers (2)

Forward Ed
Forward Ed

Reputation: 9874

another option that does the same thing.

=ROUNDUP(A1,0)

A1 is the value you want to round 0 is the number of decimals places. -1 will roundup to nearest 10, -2 to nearest 100, etc. 1 will roundup to the nearest 0.1, 2 to the nearest 0.01, etc

Upvotes: 0

Naresh Kumar
Naresh Kumar

Reputation: 1736

You can use the method CEILING

for your query 

= CEILING(A1,1)

will roundoff to next nearest number.

Ceiling takes arguments (number,significant)

Upvotes: 2

Related Questions