ROUNDING ISSUE
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.
|