Why doesn't this work !!

[Guest]

Hi,

I have a formula in worksheet 'stats' cell F8 which is

=IF('Log '!W8=0,"",'Log '!W8)
as 'Log' W8 is showing zero the result in Stats F8 is a blank cell.

so I have the same formula in worksheet stats cell G8
=IF('Log '!Y8=0,"",'Log '!Y8)
as 'Log' Y8 is showing zero why is the result in Stats G8 a zero and not a
blank??

thanks

 

[Niek Otten]

Hi Anthony,

Y8 may be *showing* a zero, but it may actually be something like
0.0000000000001
Widen the cell or try multiplying by 1000000000 to see what's in there

Niek Otten