ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ROUNDING ISSUE (https://www.excelbanter.com/excel-discussion-misc-queries/453221-rounding-issue.html)

F.G.

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

pedro

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.

[email protected]

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

Wally W.

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