View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Round up by 0.5 if =.25, down to integer if <.25

Hi,

Am Tue, 13 Dec 2016 05:57:21 -0800 (PST) schrieb :

Hi there, what would be the formula to take above criteria and apply to numbers from 1-6, for results like this:

4.15 would be 4.0
4.35 would be 4.5
4.65 would be 4.5
4.75 would be 5.0


your numbers in A1:a4. Then try:
=ROUND(A1/0.5,0)*0.5


Regards
Claus B.
--
Windows10
Office 2016