I don't think you need the "or" at all. Just checking for 0 will pick up the
"empty" 0 and the "real" 0.

So it's back to your original or the minor modification version.

CLR wrote:

Uh-huh, maybe..........I suppose it boils down to what is in the "unused"
cell, maybe the OP don't want "either" a "" or a 0 to return 0, then

=IF(OR(('Daily Input'!U42)=0,('Daily Input'!U42)=""),"",('Daily Input'!U42))

(I gave the OP back their ()'s.....some folks just feel more comfortable
with them)<g

Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote in message
...
What happens if U42 really holds a 0?

Maybe a slight change would be better:

=IF('Daily Input'!U42="","",'Daily Input'!U42)

(I got rid of some ()'s, too.)



CLR wrote:

Replace your formula with this

=IF(('Daily Input'!U42)=0,"",('Daily Input'!U42))

Vaya con Dios,
Chuck, CABGx3

"Krefty" wrote in message
...
Thanks in advance for reading this. I have a lookup function
returning
whatever sheet (X) has from a specific cell. I would like it to
return
nothing if I am not useing that cell, right now it brings in a 0?

=('Daily Input'!U42) This is the actual command that I am using....



--

Dave Peterson

--

Dave Peterson