Partial Rounding

[Harold R.]

Fairwind thanks for the formula, It does part of what I want but as usual I didn't explain very well. The Formula you gave me: =MROUND(A1,0.25) Does round the number to the closest.25. After pluging it into my worksheet I realized that I only want to Round up from .88 up to the next whole Number and round down from .12 to the next whole number. I hope this is the last question I have to bug anyone with for awhile.

 

[Oaktree]

=IF(ABS(ROUND(A1,0)-A1)<0.12,ROUND(A1,0),A1)

 

[Scott Huish]

What do you want to do if the fractional part of the number is greater than .12 and less than .88?

 

[Harold R.]

Then just show the number as it is entered.

 

[fairwinds]

ADVERTISEMENT

Hi,

Did not understand your last question in the other thread, sorry.

=IF(ABS(ROUND(A1,0)-A1)<0.13,ROUND(A1,0),A1)

should do.

 

[Harold R.]

The formula returns a 0 but I need it to return the whole number ie:7.88=8.00 or 8.12=8.00

 

[fairwinds]

Book1
	A	B	C	D
1	4.7		4.7
2	4.82		4.82
3	4.94		5
4	5.06		5
5	5.18		5.18
6	5.3		5.3
7	5.42		5.42
8	5.54		5.54
9	5.66		5.66
10	5.78		5.78
11	5.9		6
12	6.02		6
13	6.14		6.14
14	6.26		6.26
15	6.38		6.38
16	6.5		6.5
17	6.62		6.62
18	6.74		6.74
19	6.86		6.86
20	6.98		7
21	7.1		7
YTD UK

 

[Harold R.]

Fairwind Thanks very much it works great. As I said I hope not to bother anyone for awhile. This Forum is an unbeliveable help.