software

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 amp; Store Name Dump'!G108=C111,'Rep amp; Store Name Dump'!H108,quot;quot;)

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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

=IF(AND('Rep amp; Store Name Dump'!G108=C111,'Rep amp; Store Name
Dump'!H108lt;gt;quot;quot;),'Rep amp; Store Name Dump'!H108,quot;quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Jimquot; gt; wrote in message
...
gt; How do I write the following to show a blank in the cell, it is currently
gt; returning a zer because the cell it is pulling from has a 0 value.
gt;
gt; =IF('Rep amp; Store Name Dump'!G108=C111,'Rep amp; Store Name Dump'!H108,quot;quot;)
gt;
gt; Also, how do I write the following to return a blank, it is referringt o a
gt; blank cell
gt;
gt; =SNPT!C110
gt;
gt; Thanks
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
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,quot;quot;,SNPT!C110)

PeteI think I'd use:

=IF(SNPT!C110=quot;quot;,quot;quot;,SNPT!C110)

Just in case C110 on SNPT really contained a 0.

Pete wrote:
gt;
gt; For the first question you can use conditional format on the cell -
gt; conditions: if cell contents = 0, set foreground colour to background
gt; colour (white?)
gt;
gt; For the second question you can do a similar thing as in your first
gt; formula, i.e.
gt;
gt; =IF(SNPT!C110 = 0,quot;quot;,SNPT!C110)
gt;
gt; Pete

--

Dave Peterson

Yes, good point Dave.

Pete