Rounding of ,5

%3CLINGO-SUB%20id%3D%22lingo-sub-2165919%22%20slang%3D%22en-US%22%3ERounding%20of%20%2C5%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2165919%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20working%20out%20a%20score%20and%20the%20rounding%20of%20%2C5%20is%20detriment%20to%20the%20total%20score.%20What%20formula%20can%20I%20use%20to%20round%20down%20the%20decimal%20if%20its%20below%20%2C5%20and%20up%20if%20its%20%2C5%20and%20more%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2165919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi, I am working out a score and the rounding of ,5 is detrimental to the total score. What formula can I use to round down the decimal if its below ,5 and up if its ,5 and more?

 

Is there a way that I can add rounding to this formula? The rounding should occur on this part of the formula =((Q4-R4)

 

=((Q4-R4)*S4)+'Point System'!J1

1 Reply

@Janedb 

 

=ROUND(Q4-R4,0)*S4+'Point system'!J1