Please Help! Struggling with 'ISNUMBER' and 'OR' functions

[Excelnoob1995]

Hi,

I'm trying to make a column that will be used to inform a pivot table, however because the data sheet is populated by dates and not numbers, if i take data from both columns for the pivot table, there will be an overlap and inflation of resulting totals where both columns contain information. I think I need an ISNUMBER formula that will produce a text / result IF either column has information, or if they both do.

So it needs to do something like

IF CELL-A = (ISNUMBER) AND CELL-B = (ISNUMBER) THEN "YES"
IF CELL-A = (ISNUMBER) AND CELL-B = ("") THEN "YES"
IF CELL-A = ("") AND CELL-B = (ISNUMBER) THEN "YES"
IF CELL-A = ("") AND CELL-B = (I"") THEN ""

If anyone can help, this would be really great!

Kind regards,

 

[etaf]

IF CELL-A = (ISNUMBER) AND CELL-B = (ISNUMBER) THEN "YES"
IF CELL-A = (ISNUMBER) AND CELL-B = ("") THEN "YES"
IF CELL-A = ("") AND CELL-B = (ISNUMBER) THEN "YES"
IF CELL-A = ("") AND CELL-B = (I"") THEN ""

=IF( AND(A1="", B1=( I"") , "",
BUT not sure what ( I"") means - is that just a PIPE
=IF( AND(A1="", B1="I") , "", IF( OR ( AND ( ISNUMBER(A1), ISNUMBER(B1)) , AND( ISNUMBER(A1), B1="") , AND ( A1="", ISNUMBER ( B1))),"yes", ""))

I have setout as you have written , but there maybe ways to simplify or use a IFS()


=IF(AND(A1="",B1="I"),"",IF(OR(AND(ISNUMBER(A1),ISNUMBER(B1)),AND(ISNUMBER(A1),B1=""),AND(A1="",ISNUMBER(B1))),"yes",""))