Excel question on rounding

  silliw 09:59 09 Jul 2004
Locked

I wish to round calculated figures to the nearest 0.5 ie 6.3=6.5 and 8.1= 8.0 . have tried combinations of floor and ceiling functions buut have not beenvery successfull. Any ideas please.

  VoG II 10:22 09 Jul 2004

=ROUND(B3/0.5,0)*0.5

  silliw 13:12 09 Jul 2004

Many Thanks

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?