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