Thread: ROUNDING ISSUE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pedro pedro is offline
external usenet poster
 
Posts: 14
Default 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.