Rounding of ,5

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