I have a calculated number in a cell with 1 decimal place.
If the decimal is < .5, I want to round it down to an integer,
if it is .5, I want to leave it as is,
and if it is > .5, I want to round it up to the next higher integer.

Does anyone have any suggestions as to how to do this?

Thanks in advance,

Giles.

=ROUND(cell,0)

You might like to check it handles negative numbers how you want. And exact xx.5 values

HTH

I am aready using the round(x,1) function, and it returns the value I am trying to change. Round does not return the result I need.

Giles

My mistake, Giles. I didn't read your question fully.

What you want requires a test to know the numbers that are exactly xx.5.

One solution would be
=IF(A1-INT(A1)=0.5,A1,ROUND(A1,0))

Another one
=IF(INT(2*A1)=2*A1,A1,ROUND(A1,0))

Instead of these formulaic approaches, you could create a custom/user defined function in VBA.

HTH,
Fazza