IF cell## exist and cell ## exists, then show cell## else, show 0

Try this formula. It assumes that with 'exist' you mean a cell is not-blank:

=IF(AND(IF(A1<>"",1,0),IF(B1<>"",1,0)),"Cell",0)

This gives the following results. Is this what you are looking for?
...........A.......B......Result
...1......12....asa.....Cell
...2......23..................0
...3..............dsd........0
...4.............................0

Henno
mk2 6 nr 6