Data in columns A or B = number, display in column C

[scolty1985]

I have 2 columns, either they are both false, or 1 is a number. If one is a number, i want to copy that value to column C.

[TABLE="width: 254"]
<colgroup> </colgroup><tbody>[TR]
[TD="width: 124, align: right"]0.00032[/TD]
[TD="width: 130, align: center"] FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]0.000855[/TD]
[TD="align: center"] FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]5E-06[/TD]
[TD="align: center"] FALSE[/TD]
[/TR]
[TR]
[TD="align: center"] FALSE[/TD]
[TD="align: right"]0.00037[/TD]
[/TR]
</tbody>[/TABLE]

So column C would be

0.00032
0.000855
5E-06
0.00037

 

[Aladin Akyurek]

I have 2 columns, either they are both false, or 1 is a number. If one is a number, i want to copy that value to column C.

[TABLE="width: 254"]
<tbody>[TR]
[TD="width: 124, align: right"]0.00032[/TD]
[TD="width: 130, align: center"] FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]0.000855[/TD]
[TD="align: center"] FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]5E-06[/TD]
[TD="align: center"] FALSE[/TD]
[/TR]
[TR]
[TD="align: center"] FALSE[/TD]
[TD="align: right"]0.00037[/TD]
[/TR]
</tbody>[/TABLE]

So column C would be

0.00032
0.000855
5E-06
0.00037

Try...

=LOOKUP(9.99999999999999E+307,A2:B2)

 

[klingklang]

I'm sure there are many better ways to do this, but this dumb one should do in column C:

=IF(AND(ISLOGICAL(A1),ISLOGICAL(B1)), "", IF(ISLOGICAL(A1),B1,A1))

 

[scolty1985]

Both work. Thanks very much guys!

 

[Peter_SSs]

Both work.

But they do return different results if both cells are FALSE, which was a stated possibility. What result do you want if both FALSE?

 

[scolty1985]

@Peter_SSs i hadnt picked up on that . Id modified KlingKlangs so that the "" is replaced with a reference to another cell. Pretty sure its working as i need it to now (touch wood)!

 

[Peter_SSs]

Id modified KlingKlangs so that the "" is replaced with a reference to another cell.

Then what about just

=IF(COUNT(A1:B1),A1+B1,$J$1)

 

[scolty1985]

@Peter_SSs thats quite a neat way of doing it, thanks very much!!