Thread
:
Round up by 0.5 if =.25, down to integer if <.25
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch