Home 
Search 
Today's Posts 
#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! 
#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

Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Round Up and Round Down Time  Excel Worksheet Functions  
How do I add an integer to an existing integer?  Excel Worksheet Functions  
How do I round a formula result to the next integer?  Excel Worksheet Functions  
HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380  Excel Worksheet Functions  
How do I ROUND() round off decimals of a column dataset?  Excel Worksheet Functions 