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

=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

For the first question you can use conditional format on the cell -
conditions: if cell contents = 0, set foreground colour to background
colour (white?)

For the second question you can do a similar thing as in your first
formula, i.e.

=IF(SNPT!C110 = 0,"",SNPT!C110)

Pete

I think I'd use:

=IF(SNPT!C110="","",SNPT!C110)

Just in case C110 on SNPT really contained a 0.

Pete wrote:

For the first question you can use conditional format on the cell -
conditions: if cell contents = 0, set foreground colour to background
colour (white?)

For the second question you can do a similar thing as in your first
formula, i.e.

=IF(SNPT!C110 = 0,"",SNPT!C110)

Pete

--

Dave Peterson

Yes, good point Dave.

Pete