Yes it is. In the round function specify the units rounded to after the
value being rounded

(ie FLOOR(B5,.5))


" wrote:

Hi
is it posible to use the rounding to round a calculation to the nearest
half,

ie 2.24 = 2
2.26 = 2.5 etc

Kev