Oct 4, 2004 #1 AGGGG Programmer Joined Oct 8, 2003 Messages 20 Location GB Hi, I am trying to round a number down to the nearest half whole no.: 97.9 would become 97.5 97.6 97.5 97.5 97.5 97.4 97 Help would be appreciated, Andy
Hi, I am trying to round a number down to the nearest half whole no.: 97.9 would become 97.5 97.6 97.5 97.5 97.5 97.4 97 Help would be appreciated, Andy
Oct 4, 2004 #2 ilses Technical User Joined May 31, 2001 Messages 235 Location DE Hi Andy, Use FLOOR: =FLOOR(A1,0.5) assuming your number is in A1. Ilse Upvote 0 Downvote
Oct 4, 2004 Thread starter #3 AGGGG Programmer Joined Oct 8, 2003 Messages 20 Location GB Many thanks, Andy Upvote 0 Downvote