=if returning 0

J

Jim

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/com...dg=microsoft.public.excel.worksheet.functions
 
B

Bob Phillips

=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 said:
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.
Click to expand...
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
P

Pete

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
 
D

Dave Peterson

I think I'd use:

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

Just in case C110 on SNPT really contained a 0.
 
Top