Contributor

# 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

# Re: Rounding of ,5

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