Roundup Formula

[WESTERNWALL]

Hi

Can anyone help?

I need a formula to help me round up prices. If a price is between $10.01 to $10.49 to round up to $10.50. If a price is $10.51 to $10.99 to round up to $11.00.

Thanks

Brian

 

[VoG]

Try

=CEILING(A1,0.5)

 

[grizz]

if your number is in A1 then in B1 put

=CEILING(A1,0.5)

 

[WESTERNWALL]

Thanks, as always, guys.