ROUNDING ISSUE
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 |
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. |
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 |
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 |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com