Joined: 08 Jan 2014
Online Status: Offline
Posts: 29
Posted: 09 Jan 2014 at 5:18am
I'm sorry. I realize my questions are very basic. Exactly where to I put the round formula? How do I put it in the formula field along with my formula? It says that it does not appear to be a part of the formula.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 09 Jan 2014 at 5:56am
I saw your other post on "bankers rounding" so a word of caution here.
please be aware that the options given in this post are applying the rounding before any sum is taking place which can give you a different result than doing the sum first and then the rounding on that sum.
Joined: 08 Jan 2014
Online Status: Offline
Posts: 29
Posted: 09 Jan 2014 at 6:12am
Thank you for the heads up, I will keep that in mind. In this situation, to match results I am getting from the MySql rounding, applying the rounding before summing works best. You have been a huge help to me, thanks again.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
