If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Round up by 0.5 if >=.25, down to integer if <.25
Hi there, what would be the formula to take above criteria and apply to numbers from 16, 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 Another way to say it is rounding up or down to the nearest 0.5, with rounding threshold at 0.25. Thanks! 
Ads 
#2




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 16, 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 
#3




Round up by 0.5 if >=.25, down to integer if <.25
On Tuesday, December 13, 2016 at 2:57:25 PM UTC+1, wrote:
> Hi there, what would be the formula to take above criteria and apply to numbers from 16, 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 > > Another way to say it is rounding up or down to the nearest 0.5, with rounding threshold at 0.25. > > Thanks! Perfect, thanks Claus! 
#4




hÃ*ng tá»‘t giÃ¡ ráº» cÃ³ dá»‹ch vá»¥ giao hÃ*ng thu tiá»n táº*n nÆ¡i Ä‘áº£m báº£o cho khÃ¡ch hÃ*ng. phá»¥ báº¡n má»™t tay chÃºc báº¡n ngÃ*y phÃ¡t triá»ƒn
_________________ rau sáº¡ch https://t.co/lupqwTD3JG 
#5




Thanks bÃ¡c, giá» mÃ¬nh má»›i biáº¿t Ä‘áº¿n thÃ´ng tin há»¯u Ã*ch nÃ*y. Ai cÃ³ nhá»¯ng thÃ´ng tin dáº¡ng nhÆ° tháº¿ nÃ*y post lÃªn cho má»i ngÆ°á»i cÃ¹ng tham kháº£o luÃ´n nhÃ©. Äang ráº¥t quan tÃ¢m

Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Round Up and Round Down Time  DaveMoore  Excel Worksheet Functions  2  January 1st 10 01:00 PM 
How do I add an integer to an existing integer?  Aaron  Excel Worksheet Functions  3  December 17th 09 10:46 PM 
How do I round a formula result to the next integer?  LBurlingame  Excel Worksheet Functions  8  March 13th 09 04:57 PM 
HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380  v k abbey  Excel Worksheet Functions  5  March 22nd 08 07:45 PM 
How do I ROUND() round off decimals of a column dataset?  HÃ¸jrup  Excel Worksheet Functions  2  January 12th 05 11:50 AM 