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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?