Rounding of ,5


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



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