Turn a super small into 0

[tana]

Hi,

Can anyone help me to treat a super small number such as -2.22044604925031E-16 as 0 instead of some number in Excel?

I am wondering will ROUND function work or not? and what about TRUNC?

Thanks,

 

[StephenCrump]

I am wondering will ROUND function work or not?

Did you give it a try?

Just round to the required precision, e.g. if I am working in dollars/cents I'd use: =ROUND(A1,2)

 

[tana]

Did you give it a try?

Just round to the required precision, e.g. if I am working in dollars/cents I'd use: =ROUND(A1,2)

I was thinking about the data from work which I don't have it now.

Yes, I give it a try. When round it to 2 decimal, it is considered to be 0. Thanks,
Do you have any other thought except Round? I will try the Round method when I have the data from work tomorrow.

 

[Scott Huish]

You could truncate it to 2 decimal places.
=TRUNC(J13,2)