View Single Post
  #8   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Not really:

=ROUND(A1-1,0) will round 1.6 to 1, not 2.

In article ,
elioch <elioch.1s0oq1@ wrote:

If you want to round down at 1.5 you need to apply as

=Round(a1-1,0)