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.
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.