Then you didn't enter it correctly.

In article ,
Taylor wrote:

Thanks but your answer cut my value in half.


"JE McGimpsey" wrote:

One way:

=ROUND(A1*2,-1)/2