Hi
I am trying to create a formula where the end number is either rounded up or down to the nearest 0.5
Say B5/C5 = 1.35, how can I round it up to 1.5, similarly if the answer in 1.21 how can I round down to 1.0
I've tried ROUND and CEILING but can't figure it out.
Thanks
Paul
Bookmarks