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

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.

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

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