Excel question on rounding

  silliw 09:59 09 Jul 04
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 04

=ROUND(B3/0.5,0)*0.5

  silliw 13:12 09 Jul 04

Many Thanks

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

AMD Ryzen release date, specifications and features: Three CPUs from the Ryzen 7 range now…

1995-2015: How technology has changed the world in 20 years

Glassworks Barcelona shows how it captured the artistic imagination of Conor in A Monster Calls

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…