Feb 25 2021 06:26 AM - edited Feb 25 2021 06:30 AM
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