Round any decimal except 0.5

%3CLINGO-SUB%20id%3D%22lingo-sub-1669829%22%20slang%3D%22en-US%22%3ERound%20any%20decimal%20except%200.5%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1669829%22%20slang%3D%22en-US%22%3EHey%20all%2C%20wondering%20if%20anyone%20can%20help%20with%20a%20formula%20that%20can%20evaluate%20a%20cell%20that%20has%20repeating%20decimals%20and%20round%20that%20to%20an%20integer%2C%20but%20don%E2%80%99t%20round%20a%20cell%20that%20returns%20a%20number%20that%20ends%20in%20just%200.5.%20For%20example%20I%20want%20to%20leave%2017.5%20as%2017.5%20but%20round%2013.33333%20down%20to%2013%20and%2015.6666%20up%20to%2016.%20Any%20ideas%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1669829%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1670244%22%20slang%3D%22en-US%22%3ERe%3A%20Round%20any%20decimal%20except%200.5%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1670244%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F794558%22%20target%3D%22_blank%22%3E%40JStant9887%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EThis%20should%20do%20it.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(RIGHT(A1%2C2)%3D%22.5%22%2CA1%2CROUND(A1%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BThis%20will%20run%20against%20any%20number%20in%20cell%20A1%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Visitor
Hey all, wondering if anyone can help with a formula that can evaluate a cell that has repeating decimals and round that to an integer, but don’t round a cell that returns a number that ends in just 0.5. For example I want to leave 17.5 as 17.5 but round 13.33333 down to 13 and 15.6666 up to 16. Any ideas?
2 Replies
Highlighted

Hi @JStant9887,

This should do it.

=IF(RIGHT(A1,2)=".5",A1,ROUND(A1,0))

 This will run against any number in cell A1

Highlighted

@JStant9887 

As variant

image.png