Formula that returns a figure rounded up if lower that 0.5

[splottoman]

Hi,

I am after a formula the will round up and quantity lower than 0.5 to 0.5. This figure is derived from a formula relating to two other cells.

For instance;

A1 (8) / B1 (6) = 0.75 this will stay as 0.75

A2 (16) / B2 (6) = 0.375 this should round up to 0.5


Not sure if this can be completed in formatting or a formula is required.

Cheers
Steve

[JohnTopley]

Try

=MROUND(B1/A1,0.25)

Your post had A & B inverted.

[AliGW]

Duplicate thread closed - go here, please: http://www.excelforum.com/showthread.php?t=1168346