ROUNDING ISSUE
On Wednesday, 5 April 2017 01:51:26 UTC+10, 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.
Thank you for all you help.
Best,
Frank Gashi
The City University of New York
I think INT() will still round the result. Try TRUNC() this will truncate the number, it also has an optional arguement to set how many decimal places to keep.
Ron
|