ROUNDING ISSUE
On Wed, 05 Apr 2017 17:20:35 +0800, pedro wrote:
On Tue, 4 Apr 2017 08:51:21 -0700 (PDT), "F.G."
wrote:
Hi all,
How do I ask Excel to stop "rounding"?
I know Round up and down functions however I want excel to stop "rounding" and do not take into account the decimals.
Example:
whether the result is $1,375.35 or $1,375.85 I want excel ignore the decimals and to show $1,375 and not "round" to $1,375 or $1,376.
Check out the INT() function.
INT may produce undesired results for negative numbers:
int(-1375.35) = -1376
|