Rounding .01 to 1 instead of 0

[rohityogi]

Hi ,

I have lots of data loaded in excel by some Data Entry Operator.

Now we used some formulas to calculate values of some other cells in
other columns.

Problem is I dont want to round to lower side.
E.g

1.1 shud be 2 instead of 1.
1.3 shud also be 2
1.5 also be 2,
1.6 is also 2
1.9 also be 9

Someone please suggest me how to do this.

I cant represent values in decimal. And I want to jump to nearest
higher whole number.

regards

 

[Guest]

Assuming your inputs are all positive: =ceiling(a1,1)

 

[rohityogi]

Owesome
Thanks a lot

Assuming your inputs are all positive: =ceiling(a1,1)

 

[Montrose77]

=ROUNDUP(A1,0) should work for both positive and negative values.