Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) |