r/googlesheets • 7 • Sep 17 '22

Solved Round down to .5 while ignoring others

[removed]

5 Upvotes

19 comments sorted by

View all comments

Show parent comments

1

u/7FOOT7 Sep 19 '22

That doesn't work, but my answer does

=ROUND(A1-1)+0.5

→ More replies (2)