IF Problem
 

I am simply trying to link cells in different worksheets using SUM.
However, if a cell is empty, SUM returns a 0 but I want it to return as
empty. The formula I have written, but which returns "0" (linking cells
on a single sheet for ease of an example) is as follows:

=IF(SUM(C4)="","",SUM(C4))

Please help!!

Many thanks


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=374001

Andy,

This should work for you.

=IF(SUM(C4)=0,"",SUM(C4))
--
Jim


"andyp161" wrote:


I am simply trying to link cells in different worksheets using SUM.
However, if a cell is empty, SUM returns a 0 but I want it to return as
empty. The formula I have written, but which returns "0" (linking cells
on a single sheet for ease of an example) is as follows:

=IF(SUM(C4)="","",SUM(C4))

Please help!!

Many thanks


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=374001

Hi

Try this
=IF(IF(SUM(C4)="","",SUM(C4))=0,"",IF(SUM(C4)=""," ",SUM(C4)))

Barb

"andyp161" wrote:


I am simply trying to link cells in different worksheets using SUM.
However, if a cell is empty, SUM returns a 0 but I want it to return as
empty. The formula I have written, but which returns "0" (linking cells
on a single sheet for ease of an example) is as follows:

=IF(SUM(C4)="","",SUM(C4))

Please help!!

Many thanks


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=374001

On Wed, 25 May 2005 13:34:55 -0500, andyp161
wrote:


I am simply trying to link cells in different worksheets using SUM.
However, if a cell is empty, SUM returns a 0 but I want it to return as
empty. The formula I have written, but which returns "0" (linking cells
on a single sheet for ease of an example) is as follows:

=IF(SUM(C4)="","",SUM(C4))

Please help!!

Many thanks

Why are you using the SUM function to "link"?

Why not just =Sheet1!C4 or something similar?

YOu still need to do the IF(ISEMPTY(SHEET1!C4),"",SHEET1!C4)


--ron