PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Excel

Reply

Excel
 
Thread Tools Rate Thread
Old 07-04-2005, 06:57 PM   #1
=?Utf-8?B?SmF5?=
Guest
 
Posts: n/a
Default Excel


How do I stop "0" appearing when the linked cell is blank?
  Reply With Quote
Old 07-04-2005, 08:33 PM   #2
Chip Pearson
Guest
 
Posts: n/a
Default Re: Excel
Jay,

Write your formula like the following:

=IF(Sheet2!A1="","",Sheet2!A1)


"Jay" <Jay@discussions.microsoft.com> wrote in message
news:5C65D7CB-7602-4B6B-9D14-31C1CB2D177B@microsoft.com...
> How do I stop "0" appearing when the linked cell is blank?
  Reply With Quote
Reply

Archive


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off