=IF(AND('Rep & Store Name Dump'!G108=C111,'Rep & Store Name
Dump'!H108<""),'Rep & Store Name Dump'!H108,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jim" wrote in message
...
How do I write the following to show a blank in the cell, it is currently
returning a zer because the cell it is pulling from has a 0 value.

=IF('Rep & Store Name Dump'!G108=C111,'Rep & Store Name Dump'!H108,"")

Also, how do I write the following to return a blank, it is referringt o a
blank cell

=SNPT!C110

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...et.f unctions