Ok sorry I had to start another post here, I couldn't find one that covered my problem.
I was reading that the "ROUND" function in Excell uses bankers rounding and all I want to do is conventional rounding, like the kind your learned about in 6th grade to the nearest penny.
Example:
4.135 should round to 4.14
4.134 should round to 4.13
I'm writing some really important government financial software so I want to make sure I get this right.
Would the normal "=ROUND(A1,2)" work in this case with the above described behavior? I want to make sure I've got my understanding correct and that I won't end up with half the answers being wrong from accedently using Bankers rounding.
Thoughts?
Cheers
Seth
I was reading that the "ROUND" function in Excell uses bankers rounding and all I want to do is conventional rounding, like the kind your learned about in 6th grade to the nearest penny.
Example:
4.135 should round to 4.14
4.134 should round to 4.13
I'm writing some really important government financial software so I want to make sure I get this right.
Would the normal "=ROUND(A1,2)" work in this case with the above described behavior? I want to make sure I've got my understanding correct and that I won't end up with half the answers being wrong from accedently using Bankers rounding.
Thoughts?
Cheers
Seth