Hi,

I have a formula where I want the result to only be rounded down if the result is exactly .5 (1/2) at the end. All other results should not be rounded. I would like this to be the result of the formula, not cell formatting or anything else.

IF(A1*A2/(A2+A3) = a value that has exactly .5 at the end")"; ROUNDDOWN(A1*A2/(A2+A3));(A1*A2/(A2+A3))