if......only I could get help on this

[Guest]

If Time Card Sheet'!B1 =0 ...I want to return a blank, however if Time Card Sheet'!B1 does not =0 ...I want to return the value of Time Card Sheet'!B1
here is what i have so far...and it's not working......

=IF('Time Card Sheet'!B1,0," ",'Time Card Sheet'!B1)
thanks

 

[Anne Troy]

=IF('Time Card Sheet'!B1=0,"",'Time Card Sheet'!B1)