=ROUND(A1,0)-(INT(A1/2)*2=INT(A1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Holly" wrote in message
...
I need to set up a function that rounds numbers up to the nearest whole
number if the decimal is greater than .5 and the number is odd, and rounds
down to the nearest whole number if the decimal is less than .5 with an
odd
integer or if it is even no matter what the decimal is. Does anyone know
if
there is a way to set this up?? I am trying to help out a co-worker, and I
hit a wall with this spreadsheet.

Thanks