=ROUNDUP(A1,0) should work for both positive and negative values.
bpeltzer Wrote:
Assuming your inputs are all positive: =ceiling(a1,1)
" wrote:
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
--
Montrose77
------------------------------------------------------------------------
Montrose77's Profile:
http://www.excelforum.com/member.php...o&userid=18191
View this thread:
http://www.excelforum.com/showthread...hreadid=571263