In Excel? Such as "If X exists, then....." Anyone know?


32GB Mk. II in a WRX
Detroit, MI USA
www.PfeifferBeer.com

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

exist? I should have paid more attention in CS105 class!

32GB Mk. II in a WRX
Detroit, MI USA
www.PfeifferBeer.com

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

There is a category of functions for information about cells.
They generally return true or false (1/0).
ISBLANK ISNUMBER ISTEXT are a few.

To get the full list, pick an empty cell, type "=", and drag down the small down arrow next to the formula entry box, at the bottom of the list select "more functions". In the new dialog box pick information, on the right choose a function and read what it dose at the bottom.

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

So cell A1 might code as =IF(ISNUMBER(D5),D5,0)
If d5 evaluates to the numerical value 5, then A1 will evaluate as 5.
Text or blank or errors report as 0.

Ok Excel geek mode off now.

Hmmm, from the subject I thought this was going to be some deep and profound metaphysical or philosophical question... :-)

/Pepijn