When zero is not zero

[AUTO]

Hi Folks,

I have a cell which shows zero which is what I require.

But when I need the following cell to appear as null then excel says the value is non zero.

On running the formula evaluator I find that the value is not zero but something like .0000000007.

I should know how to correct this, but I'm having a senior moment (this is happening more often these days) :-/

Someone put me out of my misery please.

 

[Hui]

Depending on what formula you've got in the cell

a simple If will help or and Int


eg:

=If(Your Formula < 0.5,0, Your Formula)


=If(abs(Your Formula) < 0.5,0, Your Formula)


=int(Your Formula)

 

[AUTO]

Thanks Hui,

It was the ABS function I had needed.

Thanks again

Auto