assign blank cell when formula value totals zero

[AMD1]

Hi, I have a sum column which assigns a value of 1,2 or 3 if a C,D or CD is within a cell of the adjacent table. The formula used for this is on each row is =IF(A1="C",1,0)+IF(B1="D",1,0)+IF(C1="CD",3,0) however when a row has no data in at all, I want the cell to be be blank but as you can see from the attached, the value is shown as "0"

Its probably a simple error in the formula used but I am new to excel calculations and would appreciate a little help if possible please.

Many Thanks

Andy

[Harribone]

Just needs another If statement:

Please Login or Register  to view this content.

[dredwolf]

for your formula you can use a 'wrapper' IF, it makes the formula longer, but does what you want :
=IF(IF(A1="C",1,0)+IF(B1="D",1,0)+IF(C1="CD",3,0)>0,IF(A1="C",1,0)+IF(B1="D",1,0)+IF(C1="CD",3,0),"")

I'm sure there are other solutions, but at this moment it was all I could come up with ...

Hope this helps

[AMD1]

Hi and thanks for your responses.

That works fine, just what I was looking for.

Andy