Forum Discussion
Strange error when "if" function is used
I'm fighting whit a problem when I use "IF" function in a file like to the one attached... If I write a simple formula like the ones in coloumn "E", the results are ever correct. But, if i use the ...
Hi zazaz1 if you look at the cells in red you will see they are formatted as General, Change the format to Number and the results changes to zero. The number you see is actually defaulted to Scientific.
Rich
The number will be shown as zero, but actually that will be another (small) number. If compare to zero result will be FALSE.