Rounding .01 to 1 instead of 0
 

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

Rounding .01 to 1 instead of 0
 

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

Rounding .01 to 1 instead of 0
 

Owesome
Thanks a lot :)



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

Rounding .01 to 1 instead of 0
 

=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