One way:

=ROUND(A1,0)-(MOD(A1,1)=0.5)

In article ,
aries0070
wrote:

I want to round of number for example:

1.5 = 1
1.6 = 2

What function should I use. Please help me. Thanks