Roundup to 2 decimal places

[hsandeep]

I get values in D5:D999 as 145.0056 & so on. In E5:E999 I make it 145.01 since 3rd decimal place is 5 (or >5). Then in F5:F999 I manually punch .24 & in G5:G9999 I ADD 145.01 + .24 to get 145.25.
Objective is: The value should be having 2 decimal places with either .00, .25, .50 or .75.
Ex:
145.00789 145.25
145.20 145.25
145.56 145.75
145.00 145.00
145.304 145.50
145.99 146.00
145.755 146.00
How to accomplish?
Thanks in advance

 

[T. Valko]

I get values in D5:D999 as 145.0056 & so on. In E5:E999 I make it 145.01 since 3rd decimal place is 5 (or >5). Then in F5:F999 I manually punch .24 & in G5:G9999 I ADD 145.01 + .24 to get 145.25.
Objective is: The value should be having 2 decimal places with either .00, .25, .50 or .75.
Ex:
145.00789 145.25
145.20 145.25
145.56 145.75
145.00 145.00
145.304 145.50
145.99 146.00
145.755 146.00
How to accomplish?
Thanks in advance

Like this...

Book1
	A	B
2	145.0079	145.25
3	145.20	145.25
4	145.56	145.75
5	145.00	145.00
6	145.304	145.50
7	145.99	146.00
8	145.755	146.00
Sheet1

This formula entered in B2:

=CEILING(A2,0.25)

Format as Number 2 decimal places.

Copy down as needed.

 

[hsandeep]

Thanks. IT WORKS.

 

[T. Valko]

Thanks. IT WORKS.

You're welcome. Thanks for the feedback!